**Using the Excel CHOOSE Function**

## Summary

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.## Syntax

=CHOOSE (index_num, value1, [value2], ...)## Syntax Breakdown

**Index_num**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.

**Value1**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**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.

**CHOOSE Errors**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.

**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.