Description
The Excel CHOOSE function chooses a value from a list of values based on a given index. CHOOSE can be used to selected one of up to 254 values based on the index number.
Syntax
CHOOSE( index_num, value1, [value2], … )
Arguments
index_num – A value specifying which value argument to select
value1 – First value in the value list. This first value is required.
value2 – [Optional] Second value in the value list. The second and all subsequent values are optional.
Return value
The value at the given index
How to use the CHOOSE function in Excel
Use the Excel CHOOSE function to return a value from a list of value at a given position or index. In this context, the provided index_num argument has to correspond to the position of the respective value.
Be aware that you have to provide all values to choose from separately through the value1, value2, etc. arguments. In other words, you cannot use the CHOOSE retrieve items from a provided range of values.
In the above example, one of multiple city names is returned using the following formula:
= CHOOSE((3, “Miami”, “Dallas”, “New York”)) // returns New York
Alternatively, the value arguments can also be references, like e.g. cell A21.
Additional Notes
The Excel CHOOSE function expects a value for the index_num argument that corresponds to the number of provided values. If the index_num argument is out of range, CHOOSE will return a #VALUE! error.
Formula examples
Related Tutorials
Related Functions
Excel IFS function
The Excel IFS function allows you to perform multiple logical tests and returns a value that corresponds to the first TRUE result
Excel IF function
The Excel IF function allows you to perform a simple logical test and returns one value for a TRUE result, and another value for a FALSE result.
Excel VLOOKUP function
The Excel VLOOKUP function searches for a value by matching on the first table column and returns the corresponding value from a column in the same row.
Excel SWITCH function
The Excel SWITCH compares one value against a list of values, and returns a result value corresponding to the first match.
