# CHOOSE

## Content

This function returns a value from a list of values.

## Syntax

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

## Arguments

This function has these arguments:

| Argument | Description |
| -------- | ----------- |
| *index* | [Required] Specifies which value argument is selected. *Index* must be a number between 1 and 254, or a formula or reference to a cell containing a number between 1 and 254. |
| *Value1, value2, ...* | Value 1 is required, subsequent values are optional. 1 to 254 value arguments from which CHOOSE selects a value or an action to perform based on *index*. The arguments can be numbers, cell references, defined names, formulas, functions, or text. |

The value arguments can be range references as well as single values. For example, the formula:
`SUM(CHOOSE(2,A1:A25,B1:B10,C1:C5))`
evaluates to:
`SUM(B1:B10)`
which then returns a value based on the values in the range B1:B10.

## Remarks

This function is evaluated first, returning the reference B1:B10. The SUM function is then evaluated using B1:B10.

## Examples

`CHOOSE(3,A1,B1,C1,D1,E1)` 
`CHOOSE(3,R1C1,R1C2,R1C3,R1C4,R1C5)`
`CHOOSE(2,"dogs","birds","fish","cats","mice")` gives the result birds