How to use SWITCH Function in Excel

Description: Switch functions basically replace on given expression against your value which is being prescribed in the function. Like in the above example we have country abbreviations like US, UK, CA, etc and we want to replace such expressions with a full country name like United states for the US, the United Kingdom for Uk, and Canada for CA respectively. We will use the SWITCH and Helper function i.e. RIGHT function to do that.

Switch Function Expression;

SWITCH (expression, value1, result1, [default or value2, result2],…[default or value3, result3])

Follow the video with below table content to browse through the timeline.

00:00 Introduction
01:50 Switch Function in Excel
08:30 Switch Function Limitation
09:38 Conclusion