🎛️ The Clean Swap

Goal: Convert a numeric Priority Code (1, 2, 3) into a Text Label.
SWITCH swaps specific values for results. It is cleaner than Nested IFs for exact matches.

Current Value (Cell A1)
?
Ready...

💻 Formula Structure

=SWITCH(expression, val1, res1, [val2, res2], ..., [default])
  • 1. Expression: The value to check (e.g., Cell A1).
  • 2. Val/Res Pairs: If equal to Val, return Res.
  • 3. Default: (Optional) Return this if no match found.
-- Map ID to Priority Name
=SWITCH( A1,
  1, "Low",
  2, "Medium",
  3, "High",
  "Unknown" )
Result:
-

⚠️ Common Pitfalls

🚫 Exact Match Only
SWITCH cannot do ranges (like ">50"). It only checks for "Equals". Use IFS for ranges.
🚫 The Default Trap
The final argument is the "Default". If you forget it and no match is found, Excel returns an #N/A error.