For business users of Microsoft Excel Free guides and templates
Home >  Excel Help >  Excel Functions >  

Lookup and reference

CHOOSE Function

Chooses a value or reference from a list of values or references

by Charley Kyd, MBA
Microsoft Excel MVP, 2005-2014
The Father of Spreadsheet Dashboard Reports

Uses index_num to return a value from the list of value arguments. Use CHOOSE to select one of up to 254 values based on the index number.

For example, if value1 through value7 are the days of the week, CHOOSE returns one of the days when a number between 1 and 7 is used as index_num.


CHOOSE(index_num, value1, value2, ...)

  • index_num  Required. Specifies which value argument is selected. Index_num must be a number between 1 and 254, or a formula or reference to a cell containing a number between 1 and 254.

    • If index_num is 1, CHOOSE returns value1; if it's 2, CHOOSE returns value2; and so on.

    • If index_num is less than 1 or greater than the number of value arguments, CHOOSE returns the #VALUE! error value.

    • If index_num is a fraction, it is truncated to the lowest integer before being used.

  • value1  Required. The first argument from which CHOOSE selects a number, cell reference, defined name, formula, function, or text.

  • value2, ...  Optional. 1 to 254 value arguments from which CHOOSE selects a value or an action to perform based on index_num.

Applies To

Excel 2003 and above


You can download this example workbook here, along with all other example workbooks I've completed for this Excel help area.

Examples for Excel's CHOOSE function

Other Help


Charley's SwipeFile charts

Free Excel Dashboards