How To Use Switch function In Excel | Combine Switch With Vlookup Function | Learn in 5 Minutes
In this video, we will learn how to use switch function and how switch function is better then nested if. You will also learn how to combile switch function with vlookup function to maket if more powerful.
Nested If: • How to Use Nested IF function in Microsoft...
Vlookup: • How to use Vlookup function in Microsoft E...
Chapters
00:00 - Intro
00:43 - Application of Switch Function
02:10 - Drawback of Switch Function
02:22 - Comparison with nested if
02:40 - Combine Switch with Vlookup Function
05:15 - Closure