Excel Function : CHOOSE

Download now!

Excel Function : CHOOSE

Category

Lookup and reference

Description

Chooses a value from a list of values

Microsoft Excel Reference Page

https://support.office.com/en-us/article/CHOOSE-function-fc5c184f-cb62-4ec7-a46e-38653b98f5bc

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.