<< Click to Display Table of Contents >> CHOOSE (choose value from list)

Syntax:

CHOOSE(Index, Value1 [, Value2, Value3 ...])

Description:

This returns the value with the specified Index from a list of values.

Index specifies the position in the list of arguments. If Index is 1, the first value will be returned, if Index is 2, the second value will be returned, etc.

If Index is smaller than 1 or greater than the total number of values, the function returns a #VALUE! error value.

Example:

CHOOSE(2, "One", "Two", "Three") returns Two

See also:

SWITCH, INDEX, VLOOKUP, HLOOKUP