This Excel tutorial explains how to use the CHOOSE function with syntax and examples.
Excel CHOOSE function Description
The Microsoft Excel CHOOSE function returns a value from a list of values based on a given position.
The CHOOSE function is a built-in function in Excel that is categorized as a Lookup/Reference Function. It can be used as a worksheet function (WS) and a VBA function (VBA) in Excel. As a worksheet function, the CHOOSE function can be entered as part of a formula in a cell of a worksheet. As a VBA function, you can use this function in macro code that is entered through the Microsoft Visual Basic Editor.
Explanation: The Excel 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.
The syntax for the CHOOSE function in Microsoft Excel is:
CHOOSE( position, value1, [value2, ... value_n] )
The CHOOSE function returns any datatype such as a string, numeric, date, etc.
If position is less than 1, the CHOOSE function will return #VALUE!.
If position is greater than the number of the number of values in the list, the CHOOSE function will return #VALUE!.
Note: If position is a fraction (not an integer value), it will be converted to an integer by dropping the fractional component of the number.