Excel CHOOSE function

How to use the Excel CHOOSE function


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.


CHOOSE( index_num, value1, [value2], … )


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

How to use the Excel IFS function

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

How to use the Excel IF function

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.

How to use the Excel VLOOKUP function

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.

How to use the Excel SWITCH function

Excel SWITCH function

The Excel SWITCH compares one value against a list of values, and returns a result value corresponding to the first match.