CHOOSE

Finds the value located at a specified index

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

Returns the element within value list located at index

Inputs

Output

Returns the value associated with the provided index

Example

CHOOSE(3, "Alabama", "Alaska", "Arizona", "Arkansas") = "Arizona"

Last updated