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.

Download the Excel file here: [ Ссылка ]

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!

View my comprehensive courses: [ Ссылка ]

Connect with me on LinkedIn: [ Ссылка ]

свернуть