SWITCH Function - Your alternative for NESTED IF | DYNAMICALLY change array in VLOOKUP using SWITCH

In this video, we will learn how SWITCH is a better alternative to NESTED IF. Further, we will check an example of VLOOKUP where we need to SWITCH between the tabs for ARRAY.

#excelswitchfunction #vlookup #excelformulasandfunctions

Download this sample Spreadsheet from here: https://drive.google.com/file/d/1lPfaMFpCMq0HJTJmHkf4GrFw3SaP8rO0/view?usp=sharing

VLOOKUP tutorial: https://www.youtube.com/watch?v=rmc4o4cszM4

Check these rarely used excel functions: https://www.youtube.com/watch?v=LfbAYIc5Or0

Filter function tutorial: https://www.youtube.com/watch?v=oeV5e7iDqUk

SWITCH Function - Your alternative for NESTED IF | DYNAMICALLY change array in VLOOKUP using SWITCH ------------------------

Welcome to Excel is Simple. A place where excel is taught in the dumbest possible way. You will find every type of excel tutorial; excel 2013 tutorial for beginners, excel 2010 tutorial for beginners, excel formulas and functions, excel pivot table tutorial, excel vlookup. Aptly this is one place which has all excel tutorial for beginners. Subscribe to my channel at http://www.youtube.com/user/excelissimple?sub_confirmation=1 Want some focused playlists. Click here and lean back: The IF formula explained: https://www.youtube.com/playlist?list=PLRJY-_DDvSgK7khaQJLqhry-PELQ0hLTe All excel formulas in one place: https://www.youtube.com/playlist?list=PLRJY-_DDvSgKsM7G8qQEAa3oWLDCUn401 Excel basics if you have just started: https://www.youtube.com/playlist?list=PLRJY-_DDvSgLUOnfRBwVQYZVVzOxaVz76

Share, like and post any questions on the videos ... https://www.youtube.com/watch?v=_W2PmRfSKzY