Skip to main content

CHOOSE

Returns the value at the specified index from a list of passed arguments.

Syntax

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

Arguments

NameDescription
IndexIndex of item to retrieve
Value1First value in list
Value2, ...Optional. Other values for the list

Return Value

The value at specified index or #VALUE!.

Example

FunctionResultComment
=CHOOSE(2, "German", "English")EnglishIndex 2 represents "English"