Trending Content - Investment Banking Forum
| +190 | UBS Accused of Favoring H-1B Workers While Cutting U.S.-Born Employees | 47 | 8m |
| +85 | IB Energy Drink Tier List / Ranking | 60 | 1h |
| +76 | PJT M&A Group Selection 2026 | 13 | 20h |
| +63 | ONLY THESE BANKS OR YOU STRUCK OUT | 19 | 2m |
| +36 | Quick Thoughts on CVC AI Sale Process | 7 | 3d |
| +34 | Feedback for internship first desk at IBD BB - personal fit, "don't be too confident" | 23 | 1d |
| +28 | Does BofA still pay its associates rat pellets? | 14 | 10h |
| +18 | What happened to Greenhill | 8 | 3d |
| +18 | Updated JPM Group Rankings | 30 | 11h |
| +18 | VP Deal Origination Credit | 2 | 18h |
Career Resources
Haven't used choose in 4 years and I'm doing fine.
Offset is great, you can add as many cases as you want by shift+space+alt+i+r and then start typing new assumptions and it won't take you hours.
Why would you press Shift + Space first? You can just press Alt + I + R to insert a row...
This isn't a fully comprehensive answer, just consider it an example of why you might choose one over the other (no pun intended). Let's say you are trying to run different scenarios in your analysis -- this can be as simple as choosing 1 of 3 different revenue cases. In a simple example like this, one may be inclined to use the CHOOSE function since there isn't a huge variety of cases to run and you are only switching one thing. You're only referencing 4 cells in the formula (the index number and 3 cells corresponding to each case value) which isn't too much of a pain setting up before you copy across. I have also heard that some less Excel-savvy senior guys who sometimes find themselves in the model may find CHOOSE functions a little more friendly.
A simple example of using one versus the other may help you see how CHOOSE can appear to be more straightforward or easy to understand than OFFSET. I am not sure what your experience with Excel is, but I am happy to PM you a few examples of applying each of to show you some of their various uses I frequently come across in IB excel work.
In one case you are using an index number to select a particular cell from a specific permutation. In the other you are using either one or two numbers to determine how/where to travel from an inputted reference cell, where that reference cell also has flexibility that you can control as you move the formula across cells. Obviously one formula is far more flexible than the other, allowing for some more creative applications. However, depending on what you need, you may forego the elegance of OFFSET and keep things simple and straightforward with CHOOSE.
Once I learned Index/Match I've never looked back. Most pliable thing out there - that I've come across at least.
Offset and choose are totally different. Offset lets you travel rows and columns, but more importantly, lets you output a 2-d array to be used within another formula/function. Choose just lets you select from a list of values based on a specified position within that list.
Choose blows.
If you anticipate knowing exactly how many cases you're going to run, then fine use chose but given that every model every has scenarios that require you to flex different aspects with new scenarios constantly being added, offset is infinitely better.
I would personally use OFFSET only as last resort, since you cant track its inputs through tracking formula dependent.
I have never used Choose lol.. Which is sad considering everything I do in Excel. I personally do Offsets or you can do Index, Hlookup, etc
To quote one of my current favorite movies, "there are many answers to the question sir, but only one right answer."
Offset.
Autem minima facere beatae. Possimus possimus nulla ipsum incidunt necessitatibus. Corrupti tenetur soluta sit est assumenda nobis impedit.
Magnam voluptatem illo et similique id dolor. In est vitae aspernatur inventore. Quos culpa officiis officiis sed beatae. Labore deserunt perferendis a aliquid impedit aut et. Asperiores quidem ut laborum nihil.
Sit aut et nam. Impedit nobis animi voluptatem voluptas.
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...