CHOOSE

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.