Returns a specified value from a list.
Syntax:
CHOOSE( n, list )
Selects the nth value from the list.
list may be a range of cells, an array, or a comma-separated list of values (which may contain cell references and also ranges of cells as one or more of its elements).
Blank elements are included in the calculation.
Example:
CHOOSE(2, 1, 7, 14)
returns the result 7
.
Note that if one of the elements of the list is an array, it is treated as a single element.
Examples:
CHOOSE(3, 1, A1:B3, 6, 8)
would return the number 6
, but
CHOOSE(2, 1, A1:B3, 6, 8)
would return a reference to the range A1:B3
.