CHOOSE function


DESCRIPTION:

Return a value from a list based on a position.

 

SYNTAX:

=CHOOSE( index_num, value1[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.