Microsoft® Excel® 2010 Formulas & Functions Inside Out

CHOOSE()

Syntax. CHOOSE(index,value1,value2,...)

Definition. This function uses an index to return a value from the value argument list.

Arguments

• index (required). Indicates the item that is selected from the value arguments.

• value1,value2,... (the first value argument is required). Value arguments divided by commas. These arguments can be numbers, cell references, defined names, formulas, functions, or text. In Excel 2007 and Excel 2010, the number of arguments is restricted to 254, and in earlier versions the limit is 29.

Background. The index argument must evaluate to an integer from 1 through 29 or 1 through 254.

You can use a formula or reference to a cell returning such a number. If index is smaller than 1 or greater than the number of value ...