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
| App | Support | Syntax & notes |
|---|---|---|
| Excel | ✔ Built in | CHOOSE(index_num, value1, [value2], ...) |
| Google Sheets | ✔ Built in | CHOOSE(index, choice1, [choice2, ...]) |
| Airtable | ≈ Workaround | SWITCH(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. |
| 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) |
Excel & Sheets use cell ranges. Paste this sample data into cell A1 of a blank sheet, then paste the formula into any empty cell.
Arguments
| Argument | What it means |
|---|---|
index_num | Which 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
| Formula | Result | Why | Copy |
|---|---|---|---|
=CHOOSE(2, "Low", "Medium", "High") | Medium | ||
=CHOOSE(WEEKDAY(A2), "Sun", "Mon", "Tue", "Wed", "Thu", "Fri", "Sat") | Day name | Turn 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:B10 | The 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.