SWITCH is one of the underused functions in Excel and this article is an attempt to encourage folks to use SWITCH function which is like SWITCH function used in Java and CASE – SELECT of VBA. This article I have published on Linkedin. Below is the link for that.
https://www.linkedin.com/pulse/excel-switch-function-excel-vba-power-bi/