When building case functionality in excel, which is your favorite function to toggle between different scenarios and why? I heard and I typically used Index/Match for a few years but the new bank that I've come to loves to use Choose. Is this common across the street? Does it matter whether you use one or the other?
| +69 | Wealthy Parents / Jaded | 22 | 17h |
| +48 | How are hours rn for SA (interns) | 29 | 5h |
| +45 | Venezuela Debt Restructuring - LAZ vs CVP | 20 | 4h |
| +40 | Background check issue IB Full Time | 23 | 17h |
| +36 | A COMPLETE GUIDE TO SUMMER INTERNSHIP RECRUITING | 8 | 1h |
| +30 | Boutique firm wants access to my LinkedIn? | 13 | 9h |
| +27 | Investment Banking in Mexico | 7 | 1d |
| +25 | MM bottom bucket bonus | 9 | 2d |
| +24 | UBS GIG, LevFin, FSG Interns working Sundays and 85 hour weeks their first week? | 12 | 13h |
| +21 | Excel macros for QOL formatting | 0 | 2d |
Career Resources
Get instant access to lessons taught by experienced private equity pros and bulge bracket investment bankers including financial statement modeling, DCF, M&A, LBO, Comps and Excel Modeling.
Ah, the great Excel debate! It's like asking someone to pick their favorite child, isn't it?
Now, I've seen a lot of folks use INDEX/MATCH, and it's a solid choice. It's versatile, powerful, and once you get the hang of it, it can be a real game-changer. It's great for looking up data in a table when you don't necessarily know which column or row the item is in. It's like VLOOKUP's beefier cousin.
On the other hand, CHOOSE is a bit of an underdog. It's not as commonly used, but it can be quite handy. It allows you to select one of up to 254 values based on the index number. It's a bit simpler than INDEX/MATCH, but it doesn't offer the same level of flexibility.
OFFSET is another interesting one. It's a bit more complex, but it can be incredibly powerful when used correctly. It allows you to refer to a range that is a certain number of rows and columns away from a certain cell or range of cells.
As for which one is the best, it really depends on the situation and personal preference. Some folks swear by INDEX/MATCH, while others prefer the simplicity of CHOOSE or the power of OFFSET. It's like choosing between a Swiss Army knife, a simple pocket knife, and a multi-tool. They all have their uses, and the best one for the job depends on the task at hand.
So, in the end, it's not so much about what's common across the street, but more about what works best for you and the task at hand. Keep experimenting and you'll find the tool that fits your hand just right. Happy Excel-ing!
Sources: Makena Capital, Year 1 in consulting - tips, tricks, advice, and unspoken rules., What additional Excel functions do you wish for?, Excel Formulas you use constantly on the job?
Modi aliquid consequatur possimus omnis error vel. Soluta consequatur totam sequi ea.
Illum voluptas corrupti quisquam repudiandae dolor eum soluta. Veniam eligendi perferendis consequatur tenetur blanditiis tenetur et qui. Inventore voluptatem sed ut voluptatum rem.
See All Comments - 100% Free
WSO depends on everyone being able to pitch in when they know something. Unlock with your email and get bonus: 6 financial modeling lessons free ($199 value)
or Unlock with your social account...