Logical Functions
Advanced
SWITCH Function
Use SWITCH function for value matching.
Task:
You are converting day numbers to day names for a scheduling application. Convert day numbers to day names using SWITCH in column B, where 1=Monday, 2=Tuesday, etc.
Learning Objectives:
- Learn SWITCH function
- Understand value matching
- Practice lookup alternatives
Hints
Solve without hints for +5 XP
The data in this exercise
This is the grid you start with. Cell references in the task — B6, C2 — point at the row numbers and column letters below.
| A | B | |
|---|---|---|
| 1 | Day Number | Day Name |
| 2 | 1 | |
| 3 | 3 | |
| 4 | 5 | |
| 5 | 7 | |
| 6 | 2 |
What this exercise teaches (contains the answer)
SWITCH function is ideal for scenarios where you need to match an expression against several exact values and return a corresponding result, often cleaner than multiple IFs for this purpose.