CHOOSE function


Return a value from a list based on a position.



=CHOOSE( index_numvalue1[value2], … )


required arguments:

index_num The first range to check.
value1 The criteria to use on criteria_range1.


optional arguments:

[value2] The second range to check.

Skillshare’s usually $10 a month, but because you’re an OfficeTuts reader you can get your first month free by clicking here. That’s unlimited access to over 18,000 classes on Excel, VBA, and much more.