CHOOSE function

Category: Lookup and reference functions

What does this function do?

Choose a value from a list of values based on an index.

Syntax:

CHOOSE(index_num,value1,value2,...)

• Index_num (required):  specifies which value argument is selected. Index_num must be a number between 1 and 254, or a formula or reference to a cell containing a number between 1 and 254.
• value1 (required): First value to choose. Arguments can be numbers, cell references, defined names, formulas, functions, or text.
• value2 (optional): From the second value are optional and up to the value 254.

Examples:

= CHOOSE (3, "A", "B", "C") = C
= CHOOSE (3, A1, A2, A3) = A3