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?
| +255 | Return Rates For Interns Are Falling? | 104 | 6h |
| +136 | UBS Americas IB: The Kids’ Table of Wall Street | 18 | 12h |
| +111 | I am a drunk MD AMA | 39 | 22h |
| +72 | Article: Why UBS's Asian M&A bankers are thriving and UBS's American M&A bankers are not | 9 | 2m |
| +64 | VP Lifestyle at Top BB Coverage Groups | 40 | 1d |
| +60 | UBS Offer Day | 23 | 12h |
| +57 | An Outsider’s View of RX Banking Out of College | 6 | 4d |
| +50 | SharePoint makes IB hours HELL | 15 | 4d |
| +40 | WF Return offers | 27 | 7h |
| +36 | I hate Wells Fargo | 6 | 8h |
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?
Dicta eos eveniet sint. A quod non quibusdam molestiae mollitia. Rerum velit dolores iusto commodi voluptas autem vitae. Est odio aliquid nihil. Cum nemo ad repellendus illo placeat.
Impedit et harum rerum ex quis. Omnis quasi dolores eveniet possimus. Ipsam quaerat ducimus doloremque fuga et aliquam perferendis. Numquam sequi itaque et omnis. Omnis nihil fuga tenetur sunt cumque minima non.
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...