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.