CHOOSE

See also A-Z Spreadsheet Function List

Description Returns a value from a list of numbers based on the index number supplied.

Syntax CHOOSE(index, item_list)

index is a number that refers to an item in item_list.

index can be a cell reference. index can also be a formula that returns any value from 1 to 29.

If index is less than 1 or greater than the number of items in item_list, #VALUE! is returned.

If index is a fractional number, it is truncated to an integer.

item_list is a list of numbers, formulas, or text separated by commas. This argument can also be a range reference. You can specify as many as 29 items in the list.

See Also INDEX function

Examples CHOOSE(2,”Q1”, “Q2”, “Q3”, “Q4”) returns “Q2”

         AVERAGE(CHOOSE(1, A1:A10, B1:B10, C1:C10)) returns the average of the contents of range A1:A10.