CHOOSE Function

CHOOSE helps you get a value from a list based on position

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

The CHOOSE function syntax has the following arguments:

• Index_num 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.

• If index_num is 1, CHOOSE returns value1; if it is 2, CHOOSE returns value2; and so on.

• Value1, value2, Value 1 is required, subsequent values are optional. 1 to 254 value arguments from which CHOOSE selects a value or an action to perform based on index_num. The arguments can be numbers, cell references, defined names, formulas, functions, or text.