CHOOSE

Finds the value located at a specified index

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

Returns the element within value list located at index

Inputs

Input	Description
index	index to search for within list of values
value1	Value to return if its index matches index
[value2...]	Additional values in value list

Output

Returns the value associated with the provided index

Example

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