CHOOSE

Lookup & referenceExcel 2007

Pick the Nth item from a list of values.

Syntax

CHOOSE(index_num, value1, [value2], …)

Examples

=CHOOSE(WEEKDAY(A2,2), "Mon","Tue","Wed","Thu","Fri","Sat","Sun")

→

=CHOOSE(A2, "Low","Medium","High")

→

Related functions

SWITCH INDEX

More Lookup & reference functions

ADDRESS AREAS COLUMN COLUMNS FORMULATEXT GETPIVOTDATA HLOOKUP HYPERLINK INDEX INDIRECT LOOKUP MATCH

← All 510 functions

Syntax follows Microsoft’s documentation. Examples are written to be pasted into a cell and checked. Argument separators may be ; in your locale. The AI explainer runs on a free community model — verify anything important.