CHOOSE Function


CHOOSE function in Excel returns the value from the given position of a list.

Function Type

Lookup and reference


Get the value at the given position of a list.

Return value

The value at the given position.




index_num – The index number otherwise position from which value is to be returned. This should be a number between 1 to 254.

value1 – first value in the list.

value2 – [optional] second value in the list. Up to 254 values arguments can be used.

Example 1


If you use an index number which is out of range, CHOOSE function will return a #VALUE! error.

Read about Excel Functions

Excel Functions in Alphabetical Order (Complete list)

Complete List of Excel Functions (Category wise)

New Dynamic Array Functions in Excel

LET Function in Excel

STOCKHISTORY Function in Excel