What it does
The first argument of CHOOSE is a position number, followed by up to 254 values. If the position is 3, the third value comes back. The values can be numbers, text, cell references or formulas.
It is mostly used to turn a small whole number from another function into something meaningful: WEEKDAY returns 1 to 7 and CHOOSE turns it into a day name. When the positions start at 1 and run in order, it is much shorter than a chain of nested IFs.
If the options depend on codes ("C", "T") or irregular numbers, SWITCH fits better. If the list is long or changes often, put the values in a table and fetch them with INDEX or VLOOKUP; that is easier to maintain.
Syntax
=CHOOSE(index_num, value1, [value2], ...)=ELEMAN(dizin; değer1; [değer2]; ...)Arguments in square brackets are optional. English Excel separates arguments with commas (,) and uses a dot for decimals; Turkish Excel uses semicolons (;) and a decimal comma. Excel shows function names in its own language when it opens the file.
Arguments
| Argument | Required | Description |
|---|---|---|
index_num | Required | Which value to pick: a number between 1 and the number of values. Any decimal part is dropped. |
value1 | Required | The value returned when index_num is 1. |
value2 | Optional | The value returned when index_num is 2; you can list up to 254 values the same way. |
Examples
1Write the day name from a date
With return_type 2, WEEKDAY gives 1 for Monday and 7 for Sunday; CHOOSE turns that position into one of seven day names. The formula in B2 is filled down.
=CHOOSE(WEEKDAY(A2,2),"Monday","Tuesday","Wednesday","Thursday","Friday","Saturday","Sunday")| A | B | |
|---|---|---|
| 1 | Delivery Date | Day |
| 2 | 2-Nov-2026 | Monday |
| 3 | 5-Nov-2026 | Thursday |
| 4 | 7-Nov-2026 | Saturday |
| 5 | 8-Nov-2026 | Sunday |
| 6 | 13-Nov-2026 | Friday |
- B2 (filled down to B6)
=CHOOSE(WEEKDAY(A2,2),"Monday","Tuesday","Wednesday","Thursday","Friday","Saturday","Sunday")
7 November 2026 gives Saturday and 13 November gives Friday. Because the names are written in the formula, the result does not depend on the language settings of the computer that opens the file.
We recalculated this example in real Excel (Microsoft 365, 16.0) and compared the results: they match.
2Work out a fee from a payment type code
Payment types are coded 1, 2 or 3, explained in F:G. CHOOSE picks one of three rates by the code and multiplies it by the amount.
=C2*CHOOSE(B2,0,0.005,0.025)| A | B | C | D | E | F | G | |
|---|---|---|---|---|---|---|---|
| 1 | Order | Payment Type | Amount | Fee | Code | Payment Type | |
| 2 | SO-701 | 1 | 2,400.00 | 0.00 | 1 | Cash (0%) | |
| 3 | SO-702 | 3 | 1,850.00 | 46.25 | 2 | Bank transfer (0.5%) | |
| 4 | SO-703 | 2 | 5,200.00 | 26.00 | 3 | Card (2.5%) | |
| 5 | SO-704 | 3 | 760.00 | 19.00 |
- D2 (filled down to D5)
=C2*CHOOSE(B2,0,0.005,0.025)
SO-702 has code 3, so it is charged the card rate: 46.25. SO-703, paid by bank transfer, has a fee of 26.00; the cash order SO-701 has 0.00.
We recalculated this example in real Excel (Microsoft 365, 16.0) and compared the results: they match.
Common errors and fixes
- #VALUE!
Cause: index_num is less than 1 or larger than the number of values, e.g. three values but index 4.
Fix: Check the formula that produces index_num, or add the missing value.
- Day names off by one
Cause: WEEKDAY was used without its return_type, so 1 means Sunday and a Monday-first list shifts by a day.
Fix: For a Monday-first list use
WEEKDAY(A2,2).
Good to know
- The values can be cells:
=CHOOSE($B$1,C5,D5,E5)takes one of three columns depending on the scenario chosen in B1. - If you get index_num from MATCH, you can turn a text into a position and the position into another value.
In Nexell
Get Nexell to do it from a sentence
Add a Day column to the delivery list that shows the weekday name of each date
Convert to tableBring your table into the tool and type this. Nexell adds the day name column with real Excel formulas and shows it in the preview; in the downloaded file, the name changes when you change a date.
Nexell uses AI to understand the request and builds the result with real Excel formulas; the formula may differ from the example on this page. You see a preview first and nothing changes until you press Apply; formulas stay live in the downloaded .xlsx file.
Free account · no card needed · 30 credits a month
Frequently asked questions
What is the difference between CHOOSE and SWITCH?
CHOOSE only works with positions such as 1, 2, 3. SWITCH compares a value with any values you list ("C", "T", 100) and can return a default when none of them match. If you have a position number, CHOOSE is shorter; if you have a code, SWITCH is.
Related functions
- SWITCHİLKEŞLEŞEN · Returns the result for the first matching value.
- INDEXİNDİS · Returns the value at a given row and column of a range.
- IFSÇOKEĞER · Returns the value of the first true condition.
- WEEKDAYHAFTANINGÜNÜ · Day of the week (1 = Sunday; type 2 makes Monday 1).
- CHOOSECOLSSÜTUNSEÇ · Returns chosen columns of an array.