The CHOOSE function returns a value from a list using a given position or index. For example, CHOOSE(2,”red”,”blue”,”green”) returns “blue”, since blue is the 2nd value listed after the index number. The values provided to CHOOSE can include references.
Purpose of Excel CHOOSE Function
Get a value from a list based on position.
Return value
The value at the given position.
Syntax
=CHOOSE (index_num, value1, [value2], …)
Arguments
| Arguments | Description | Remarks |
| index_num | The value to choose. | Mandatory |
| value1 | The first value to choose. | Mandatory |
| value2 | The second value from which to choose. | Optional |
Availability
Since 2007 for Windows.
Since 2011 for Mac.