Excel SWITCH Function, is it really as good as they say? You might be surprised!

The Excel SWITCH Function is an alternative to nested IFs, IFS, V or XLOOKUP by allowing you to replace one value with another, but does it really offer anything new or improved? In this video we compare SWITCH to IFS, VLOOKUP, XLOOKUP and CHOOSE.

0:19 SWITCH for Lookups
1:23 IFS for lookups
2:32 VLOOKUP & XLOOKUP alternatives
3:37 IFS for multiple logical tests
4:44 SWITCH for multiple logical tests
5:47 SWITCH to return Fiscal Quarters
6:39 CHOOSE to return Fiscal Quarters
7:17 Options reviewed
7:48 The bottom line!

[MichaelBrown-lwkz]

Another excellent video, and I love how you used the CHOOSE function to assign quarters to dates.

[aleksandar]

its very useful to have this analysis (compare), to show quickly if its useful for daily business or not. Thx alot to you Mynda to save us time. which is today very precious.

[manojjohnaxelsson]

You crack everything wide open and make it look so easy.... 👌

[marcelmaes]

7:50 Nice you pointed that out! I was wondering all the time why Microsoft has added this function anyway. Well at least it's easier then nested IFs 🙂.

[vijayarjunwadkar]

Thank you Mynda! It became clear as to, if we should "SWITCH" to this new function or "CHOOSE" the existing ones! Nice presentation as usual! BTW, liked the TRUE parameter logic in SWITCH! 😊👍

[roberth.]

Thank you for your perspective on the switch function.

[hendersonliu]

I agree. I prefer sticking with vlookup but good to know this formula exists! Awesome video Mynda!!!

[wayneedmondson]

Hi Mynda. Very thorough and well explained! Thanks for the compare/contrast of these useful functions :)) Thumbs up!!

[abdelkrimmesaiahmed]

The simplicity ease the comlexity thamk you Mynda for this amazing video

[teoxengineer]

Mylinda hi,
This "TRUE" trick is so wonderful and I have not ever seen it anywhere!
Thank for sharing

[Ado-]

Keep up the great work. Best channel for project management. Thank you for the hard work and free tutorials.

[paullowe]

Thank you, Mynda. That was a great explanation and really helpful.

[chrism]

Fantastic! I have never used it and learned something new, thanks Mynda

[alec]

I didn't know you can put a TRUE at the end of an IFS statement as an ELSE function. THANK YOU VERY MUCH!

[joshuabiondo]

I use the SWITCH function to SUM different columns depending on a dropdown, or even look at a different table entirely depending on a dropdown's value. Very fast function in my use cases so far. I love it!

Excellent tutorial, thank you so much. You're an awesome teacher.

[clickbisi]

🙋🏾‍♂️One of the people who mentioned Switch in the IFS video here… I gotta say… touché 😆 Great tutorial as always 👍🏾👌🏾

[IvanCortinas_ES]

Excellent Mynda!!! Great tutorial. Thanks for the detailed description.

[garys]

Thank you for helping me get better at Excel !!

[techwg]

You make my coffee mug at work more true all the time. It is a "I LOVE SPREADSHEETS" mug.