CHOOSE function

description:

Return a value from a list based on a position.

 

syntax:

=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.