CHOOSE function

The CHOOSE function is one of the lookup and reference functions. It is used to return a value from a list of values based on a specified index (position).

Syntax

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

The CHOOSE function has the following arguments:

Argument	Description
index_num	The position of the value in the list of values, a numeric value greater than or equal to 1 but less than the number of the number of values in the list of values.
value1/2/n	The list of values or the selected range of cells you need to analyze.

Notes

How to apply the CHOOSE function.

Examples

The figure below displays the result returned by the CHOOSE function.