✋ Stop Using NESTED IF Formulas in Excel, Use SWITCH Function Instead 

For all your cases, the best and lot easier function is vlookup or xlookup. Switch is way lengthy and error-prone formula.

Very well explained. SWITCH is one of the most underused functions in Excel. Many people don't even know it exists. Thanks for the tutorial, Sumit!

Thanks Sumit. Your videos always delight me about Excel as a powerful tool.

As usual, great video. I like the way Mr. Bansal explains it, I can understand it better than other videos.

I’ve always wanted to use switch but was missing the ability to add conditions. So simple, thanks!

Thanks for the tutorial, Sumit. I have tried using SWITCH, but your examples have confirmed for me that it doesn't have many uses for data with more than a couple of conditions. Perhaps a little neater than some nested IFs.

Guruji....kya baat hai...I have never seen or heard any video of switch on you tube. Thank you for bringing this to us.

Thanks for sharing on how to use the function. Thoroughly enjoyed it 😃

Oooo, something new for me to play with, thank you, I think this could be really useful.

awesome Sir , Thanks for make the example

Excellent video clearly explained ❤👍

thank you so much!

Excellent video! Is the Switch function only available in Excel 365 or is it in earlier versions?

Thanks!!

Well explained🤟

You could use the choose function as well

Thank you

Well done ❤

Thank you for thi good expression. However, if we write two true values, it returns the firts one, not second.

It seems to be an omission to not allow you to throw that table of Grade scores, for example, at the SWITCH function, instead of having to type A1>=90,"A" etc etc

Give us some example files for the practice method that will be more informative.

I would still go for vlook-up with approximate match combination

Also not work in excel 2016