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 Micr...
Vlookup: • How to use Vlookup function in Micros...
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
play_arrow
How to find duplicate values from data in excel before removing them | Learn in 5 Minutes
play_arrow
How to use Nested Xlookup to build two-way lookup in Microsoft Excel | Learn in 5 Minutes