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