CHOOSE
Returns the value at the specified index from a list of passed arguments.
Syntax
=CHOOSE(Index, Value1, [Value2, ...])
Arguments
| Name | Description |
|---|---|
| Index | Index of item to retrieve |
| Value1 | First value in list |
| Value2, ... (optional) | Other values for the list |
Return
The value at specified index or #VALUE!.
Examples
| Formula | Result | Comment |
|---|---|---|
| English | Index 2 represents "English" |