Excel Function : CHOOSE

Download now!

Excel Function : CHOOSE


Lookup and reference


Chooses a value from a list of values

Microsoft Excel Reference Page


Syntax and Description of the CHOOSE Excel Function

The syntax for the CHOOSE function in Microsoft Excel is: CHOOSE( index, value1, value2, ... ) Index is the position of the value that you want to return in the list of values. Value1, value2, ... are 1 to 29 values that you want to choose from.

About CHOOSE Excel Function

The CHOOSE function returns a value from a list of values, based on a position number.