Excel CHOOSE Function

Using the Excel CHOOSE Function


The CHOOSE function returns a value from a list of given values. The index_num argument is used to select which value from those provided will be returned. For example, if index_num is 3 and value1 is Bill, value2 is Jim, and value3 is Karen, the CHOOSE function would return Karen since this is the third value in the list.


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

Syntax Breakdown

Required. Index_num can be any number between 1 and 254 and is used to determine which value will be returned. Index_num can also be a reference to a cell containing a number between 1 and 254 or a formula.

For example, if index_num is 3 the function returns value3.

Required. Value1 is required and is the value from which the function will select a value. The argument can be numbers, cell references, defined names, formulas, other functions, or text.

Value2 and any subsequent values are optional. The function can accept up to 254 value arguments.

Usage Notes

The CHOOSE function is used to return a value from a list of provided values based on the index_num argument.

If the index_num argument is less than 1 or greater than the number of the last value, the function returns the #VALUE! error.


Fractions With CHOOSE
If the index_num argument is a fraction, it will be truncated to the lowest integer before the function is executed.

Excel CHOOSE With Fraction

CHOOSE With Other Functions
CHOOSE can be used along with other functions. For example, the value arguments in CHOOSE could refer to a range of cells. Using the SUM function, you could then sum the values in the cells indicated by index_num.

For example, you could have =SUM(CHOOSE(1, B4:B8, C4:C8, D4:D8)). This would evaluate to =SUM(B4:B8). This would then sum the values in the range B4:B8.

Excel CHOOSE with SUM