CHOOSE(index_num, list)

The CHOOSE function chooses a value from a list of values. index_num is the position of the value in list. The arguments of list can be numbers, formulas, text, cell references or ranges.

For example:

CHOOSE(3, "Sales", "Profit", "Cost") 

returns "Cost".

CHOOSE can also return a range which can be use in conjunction with other functions. For example:

SUM(CHOOSE(2, A1..A3, B1..B3, C1..C3))

returns the result of SUM(B1..B3).

See also:

Other lookup functions