CHOOSE Function in Microsoft Excel
Command: CHOOSE
Syntax: =choose(cell referencing #,value 1, value 2, value 3…value 29)
Example 1:
=choose($A$1,B1,B2,B3)
If cell A1 = 1, then it will return cell B1
If cell A1 = 2, then it will return cell B2
Use: Financial modeling for upside and downside cases. Easy to use and describe.
Limitations: Only 29 possible variables. Offset is easier to manipulate.