CHOOSE
Syntax
CHOOSE (index, item_list)
Description
Finds the value of a specific item in a list of items based on the index number supplied.
Arguments
| index | Number that refers to an item in item_list. |
| item_list | List of numbers, formulas, or text separated by commas. |
Returns
A value from a list of items.
Remarks
index can be a cell reference or a formula that returns any value.
If index is less than 1 or greater than the number of items in item_list,a record error is generated and displays in the Execution History.
Example
CHOOSE(2,"Q1", "Q2", "Q3", "Q4")
Returns:
Q2