# 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.