Description
Returns a value from a list of numbers based on the index number supplied.
Syntax
CHOOSE ( index, item_list )
| Parameter | Description |
|---|---|
| index | A number that refers to an item in item_list. |
| item_list | A list of numbers, formulas, or text separated by commas. You can specify up to 29 items in the list. |
Remarks
index can be a cell reference or a formula that returns any value from 1 to 29.
If index is less than 1 or greater than the number of items in item_list, #VALUE! is returned.
If index is a fractional number, it is truncated to an integer.
Examples
This function returns Q2:
CHOOSE(2,"Q1", "Q2", "Q3", "Q4")