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: