Syntax:
CHOOSE(n, list)
Selects the n-th value from the subsequent list, which may be an array, a range of cells, or a comma-separated list of values.
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
.