SWITCH Function in Excel: Match One Value Against a List

📎 This article includes 1 downloadable practice file ↓

LogicalLevel: IntermediateAvailable in: Excel 2019+

In this article

1. Syntax
2. Examples
3. Example 1
4. Example 2
5. SWITCH in practice
6. Where you will use it
7. Worked example
8. Mistakes people make
9. Related functions
10. Continue learning

SWITCH compares one value with a list and returns the matching result — cleaner than nested IFs for exact matches.

Syntax

=SWITCH(expression, value1, result1, [value2, result2], ..., [default])

Argument	What it means
default	Result when nothing matches.

Examples

Example 1

=SWITCH(B2, "N", "North", "S", "South", "E", "East", "W", "West", "Unknown")

Expand region codes.

Example 2

=SWITCH(WEEKDAY(A2, 2), 6, "Weekend", 7, "Weekend", "Weekday")

Weekend flag.

SWITCH in practice

Where you will use it

• Map codes to names
• Status codes to labels
• Payment mode codes

Worked example

Code	Formula	Result
C	=SWITCH(A2,"C","Cash","U","UPI","K","Card","Unknown")	Cash
U	=SWITCH(A3,"C","Cash","U","UPI","K","Card","Unknown")	UPI
X	=SWITCH(A4,"C","Cash","U","UPI","K","Card","Unknown")	Unknown

Results calculated in Excel.

Mistakes people make

Mistake	What to do instead
No default	Add a last value for unmatched codes
Ranges like >50	SWITCH matches exact values; use IFS for ranges

Related functions

IFS · IF · CHOOSE

📚 Part of the free Excel course: Beginner → Expert · Try it in the Formula Lab or ask the AI Helper.

Continue learning

All Logical guides →

TRUE Function in Excel: The Logical Value TRUETRUE() returns the logical value TRUE. You can also just type TRUE; the function…FALSE Function in Excel: The Logical Value FALSEFALSE() returns the logical value FALSE, most often seen as the exact-match argument in…MAKEARRAY Function in Excel: Generate a Grid From Row and Column NumbersMAKEARRAY builds an array of a given size, computing each cell from its row…BYCOL Function in Excel: Apply a Calculation to Each ColumnLogicalLevel: ExpertAvailable in: Excel 365 / 2021+BYCOL is BYROW turned sideways: one result per…

📎 Practice files for this article

• 📗
  Practice workbook: Logic, LET & LAMBDA17 tasks on realistic sales data — type your formula, the Check column turns green when it is right. Answers sheet included.
  ⬇ XLSX · 35 KB

Free to use for learning. Files with macros (.bas) are plain text — import them with Alt+F11 → File → Import File, and always test on a copy.