Tests an expression against a list of cases and returns the corresponding value of the first matching case, with an optional default value if nothing else is met.
Description
How To Use in Sheets
SWITCH(expression, case1, value1, [default or case2, value2], …)
External Links
SWITCH Function (Multiple IF conditions, IFS function) - Google Sheets - similar in Excel
Learn how to use SWITCH function in Google Sheets or Excel to create multiple If statements. Understand the difference between SWITCH & IFS functions. Function covered in this tutorial: SWITCH, IFS, DGET, YEAR, MONTH