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)

Leave a Reply

Your email address will not be published.Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.