Spreadsheet formulas explained, side by side

CHOOSE Function in Excel, Google Sheets, Airtable & Notion

CHOOSE takes an index number and a list of values and returns the value at that position: CHOOSE(2, "Low", "Medium", "High") is "Medium".

Syntax in each app

AppSupportSyntax & notes
Excel✔ Built inCHOOSE(index_num, value1, [value2], ...)
Google Sheets✔ Built inCHOOSE(index, choice1, [choice2, ...])
Airtable≈ WorkaroundSWITCH(index, 1, value1, 2, value2, ..., [default])
Airtable has no CHOOSE, but SWITCH with the numbers 1, 2, 3… as patterns does the same. An index with no pattern returns the default, or empty if none is given.
Notion≈ Workaround[value1, value2, ...].at(index - 1)
Put the options in a list and pick with .at(), which counts from 0. ifs() is an alternative.
Try CHOOSE with your own values
One value per line, or separate with commas
Result (as Excel & Google Sheets return it)
Medium
Your formula, ready to paste
Excel=CHOOSE(2, "Low", "Medium", "High", "Urgent") open excel.new ↗
Google Sheets=CHOOSE(2, "Low", "Medium", "High", "Urgent") open sheets.new ↗
Airtable
workaround
SWITCH(2, 1, "Low", 2, "Medium", 3, "High", 4, "Urgent")
Notion
workaround
["Low", "Medium", "High", "Urgent"].at(1)

Arguments

ArgumentWhat it means
index_numWhich value to return, from 1 to the number of values. Decimals are truncated.
value1, [value2], ...Up to 254 values, cell references or ranges to choose from.

Examples

FormulaResultWhyCopy
=CHOOSE(2, "Low", "Medium", "High")Medium
=CHOOSE(WEEKDAY(A2), "Sun", "Mon", "Tue", "Wed", "Thu", "Fri", "Sat")Day nameTurn a weekday number into a label.
=CHOOSE(5, "a", "b", "c")#VALUE!Index larger than the number of values.
=SUM(CHOOSE(2, A2:A10, B2:B10))Total of B2:B10The values can be ranges, so CHOOSE can switch which range a formula uses.

Examples use Excel / Google Sheets syntax unless noted.

How CHOOSE works

CHOOSE is a compact way to turn a small number into something else: 1–4 into quarter names, a WEEKDAY result into a day label, a score band into a rating. Each value can be text, a number, a cell or a whole range, so =SUM(CHOOSE(F1, A:A, B:B, C:C)) lets a drop-down in F1 decide which column is totalled.

The index must be between 1 and the number of values; anything else, including 0, returns #VALUE!. Decimals are cut off, so 2.9 picks the second value. When the options live in cells, INDEX on that range is easier to maintain than a long CHOOSE, and when you are matching text rather than numbers, SWITCH or IFS reads better.

Airtable has no CHOOSE, but SWITCH({Priority}, 1, "Low", 2, "Medium", 3, "High") is equivalent, with an optional last argument for anything else. In Notion, write the options as a list and pick with .at(index - 1), because Notion lists count from 0.

Frequently Asked Questions

What is the difference between CHOOSE and SWITCH?
CHOOSE picks by position (1, 2, 3…). SWITCH compares a value against any list of cases, text included, and can have a default.

Part of the Lookup & Reference functions. Results in the tester follow Excel and Google Sheets behaviour; always double-check important work in your own file.