CHOOSE

This function returns a value from a list of values.

Syntax

CHOOSE(index, value1, [value2], ...)

This function has these arguments:

Argument	Description
index	[Required] Specifies which value argument is selected. Index must be a number between 1 and 254, or a formula or reference to a cell containing a number between 1 and 254.
Value1, value2, ...	Value 1 is required, subsequent values are optional. 1 to 254 value arguments from which CHOOSE selects a value or an action to perform based on index. The arguments can be numbers, cell references, defined names, formulas, functions, or text.

The value arguments can be range references as well as single values. For example, the formula:

SUM(CHOOSE(2,A1:A25,B1:B10,C1:C5))

evaluates to:

SUM(B1:B10)

which then returns a value based on the values in the range B1:B10.

This function is evaluated first, returning the reference B1:B10. The SUM function is then evaluated using B1:B10.

CHOOSE(3,A1,B1,C1,D1,E1)

CHOOSE(3,R1C1,R1C2,R1C3,R1C4,R1C5)

CHOOSE(2,"dogs","birds","fish","cats","mice") gives the result birds