Offset Vs. Choose functions

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.