CHOOSE Function Explained
The CHOOSE function in Microsoft Excel returns a value from a list of values based on a given index number. It takes two arguments: index_num (required) and value1, value2, ... (required). The index_num argument is a number between 1 and 254 that specifies which value argument is returned. If the index_num argument is less than 1 or greater than the number of value arguments, the CHOOSE function returns the #VALUE! error value.
CHOOSE Function Syntax
CHOOSE(index_num, value1, [value2], ...)
- index_num: The position of the value in the list of values argument from which to return a value. It must be a number between 1 and 254, or a formula or reference to a cell containing a number between 1 and 254.
- value1: The first value argument from which the CHOOSE function will return a value.
- value2: (Optional) Additional value arguments from which the CHOOSE function will return a value.