Spread Formula Reference
CHOOSE
Formula Functions > Functions A to C > CHOOSE

This function returns a value from a list of values.

Syntax

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

Arguments

This function has these arguments:

Argument Description
index Index of the specified values to return; an integer value between 1 and 255
value1, etc. Values from which to choose; can have up to 255 values; can be numbers, cell references, cell ranges, 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.

Remarks

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

Data Types

The index argument accepts numeric data. The value arguments accept any data. Returns the type of data of the specified value.

Examples

CHOOSE(3,A1,B1,C1,D1,E1) gives the result C1

CHOOSE(3,R1C1,R1C2,R1C3,R1C4,R1C5) gives the result R1C3

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

Version Available

This function is available in product version 1.0 or later.

See Also

INDEX | SUM | Lookup Functions