CHOOSE function
CHOOSE uses an index to return a value from a list of up to 30 values.
Syntax
CHOOSE(index, value 1, value 2, ...)
- index is a cell reference or number from a list of values indicating which value is to be taken from the list.
- value 1, value 2, ... are the value entered as a reference to a cell or as individual values.
Note:
- If index is greater than the number of values given, CHOOSE returns #VALUE!.
- You cannot use CHOOSE to return a range reference. For example, =SUM(A1:CHOOSE(1, A2, A3)) returns #ERROR!.
Example
=CHOOSE(A1, B1, B2, B3, "Today", "Yesterday", "Tomorrow") returns the contents of cell B2 for A1 = 2. For A1 = 4, the function returns the text Today.
=CHOOSE(A1, B1, B2, B3, "Today", "Yesterday", "Tomorrow") returns #VALUE! for A1 = 8.