Lookup and reference
CHOOSE Function
Chooses a value or reference from a list of values or references
by
Charley Kyd, MBA Microsoft Excel MVP, 20052014
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.
Syntax
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
Examples
You can
download this example workbook here,
along with all other example workbooks I've completed for this
Excel help area.
Other Help
