Skip to content

Excel function · Lookup & reference

Excel CHOOSE function

CHOOSE returns one of the values listed after the index number: the first for 1, the second for 2. Use it to turn a weekday number into a name or a payment type code into a rate.

In Turkish Excel: ELEMAN

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

English Excel=CHOOSE(index_num, value1, [value2], ...)
Turkish Excel=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

ArgumentRequiredDescription
index_numRequiredWhich value to pick: a number between 1 and the number of values. Any decimal part is dropped.
value1RequiredThe value returned when index_num is 1.
value2OptionalThe 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.

B2fx=CHOOSE(WEEKDAY(A2,2),"Monday","Tuesday","Wednesday","Thursday","Friday","Saturday","Sunday")
Write the day name from a date: example table
AB
1Delivery DateDay
22-Nov-2026Monday
35-Nov-2026Thursday
47-Nov-2026Saturday
58-Nov-2026Sunday
613-Nov-2026Friday
  • 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.

D2fx=C2*CHOOSE(B2,0,0.005,0.025)
Work out a fee from a payment type code: example table
ABCDEFG
1OrderPayment TypeAmountFeeCodePayment Type
2SO-70112,400.000.001Cash (0%)
3SO-70231,850.0046.252Bank transfer (0.5%)
4SO-70325,200.0026.003Card (2.5%)
5SO-7043760.0019.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

Type this in Nexell

Add a Day column to the delivery list that shows the weekday name of each date

Convert to table

Bring 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

All lookup & reference functions →

Stop memorising formulas. Describe them.

Bring your table into the tool and say what you need; Nexell builds the formula and shows it in a preview.

Try it free