CHOOSE

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.