# CHOOSE function in Excel

> CHOOSE returns the item at a given position from a list you type into the formula: 1 returns the first item, 2 the second, and so on.

Source: https://spreadsheetpractice.com/functions/choose · Updated October 28, 2026 · Formulas and results on this page were run by the Spreadsheet Practice formula engine on November 20, 2026

## Quick answer

- **What it does:** CHOOSE returns the item at a given position from a list you type into the formula: 1 returns the first item, 2 the second, and so on.
- **Syntax:** `=CHOOSE(index_num, value1, [value2], ...)`
- **Most common use:** `=CHOOSE(ROUNDUP(MONTH(A2)/3,0),"Q1","Q2","Q3","Q4")` returns Q1 (A quarter label from a date in February)
- **Available in:** Every current version
- **Category:** [Logical functions](https://spreadsheetpractice.com/functions/category/logic)
- **Returns:** The value at position index_num, or #VALUE! when index_num is below 1 or past the end of the list.
- **Google Sheets:** Works the same way in Google Sheets.

## What it does

CHOOSE returns the item at a given position from a list you type into the formula: 1 returns the first item, 2 the second, and so on. It turns small numbers into labels, such as a month into a quarter name, and picks between rates or whole ranges based on a level or scenario number.

## Syntax

`=CHOOSE(index_num, value1, [value2], ...)`

| Argument | Required? | What it is |
|---|---|---|
| `index_num` | Required | A number from 1 to the number of values, up to 254. Decimals are dropped. |
| `value1` | Required | The value to return when index_num is 1. |
| `value2` | Optional | The value for 2, and so on. |

## Examples

Each result was calculated by running the formula on the sample sheet.

| Cell | Formula | Result | What it shows |
|---|---|---|---|
| D2 | `=CHOOSE(ROUNDUP(MONTH(A2)/3,0),"Q1","Q2","Q3","Q4")` | Q1 | A quarter label from a date in February |
| D3 | `=CHOOSE(WEEKDAY(A3),"Sun","Mon","Tue","Wed","Thu","Fri","Sat")` | Fri | A day name from the weekday number: July 3, 2026 is a Friday |
| D4 | `=CHOOSE(2,B2,B3,B4)` | $9,100 | Picks the second cell in the list |

### The sample sheet

Every formula above runs on this data:

|  | A | B | C | D |
|---|---|---|---|---|
| 1 | Date | Sales |  | Result |
| 2 | 2/14/2026 | $8,200 |  | Q1 |
| 3 | 7/3/2026 | $9,100 |  | Fri |
| 4 | 11/20/2026 | $7,600 |  | $9,100 |

## Common mistakes

| What you see | Why, and how to fix it |
|---|---|
| #VALUE! | index_num is 0, negative or larger than the number of values. Check the number feeding CHOOSE. |
| Picking by name | CHOOSE needs a position number. To pick by a word such as "High", use SWITCH or XLOOKUP. |
| Long lists typed into the formula | Past six or seven items, a lookup table with INDEX or XLOOKUP is easier to maintain. |

## Tips

- =SUM(CHOOSE($H$1,B2:B13,C2:C13,D2:D13)) switches a total between three scenarios with one input cell.

## Related functions

- [SWITCH](https://spreadsheetpractice.com/functions/switch): SWITCH compares one value against a list of exact matches and returns the result paired with the first match, with an optional default at the end.
- [INDEX](https://spreadsheetpractice.com/functions/index): INDEX returns the value at a given row and column of a range: INDEX(A2:C10,4,2) is the fourth row, second column.
- [IFS](https://spreadsheetpractice.com/functions/ifs): IFS checks a list of conditions in order and returns the value paired with the first one that is TRUE.

## Questions

### What does CHOOSE do in Excel?

It returns the nth item from a list in the formula: =CHOOSE(2,"Low","Medium","High") returns "Medium".

### What is the difference between CHOOSE and SWITCH?

CHOOSE picks by position number. SWITCH matches a value, which can be text, against a list of options.

## Practice

A graded CHOOSE exercise ("Bonus by level") is on [the CHOOSE page](https://spreadsheetpractice.com/functions/choose). It is checked instantly, then re-checked on changed data.

---

Spreadsheet Practice (https://spreadsheetpractice.com) teaches spreadsheet formulas by practice: every exercise is graded in a live grid and re-checked on changed data.
