Excel Functions

Excel CHOOSE Function

Pinterest LinkedIn Tumblr

The CHOOSE function returns a value from a list using a given position or index. For example, CHOOSE(2,”red”,”blue”,”green”) returns “blue”, since blue is the 2nd value listed after the index number. The values provided to CHOOSE can include references.

Purpose of Excel CHOOSE Function

Get a value from a list based on position. 

Return value

The value at the given position.


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


index_numThe value to choose.Mandatory
value1 The first value to choose.Mandatory
value2The second value from which to choose.Optional


Since 2007 for Windows.
Since 2011 for Mac.

Related Posts

Write A Comment