Tired of the limitations of Microsoft Excel VLOOKUP or the constant N/A errors? Within a few minutes you can rid VLOOKUP from your life. Switch to INDEX MATCH to end the tyranny of VLOOKUP forever.

In newer versions of Excel, you may find that XLOOKUP is a better alternative than INDEX MATCH but older versions of Excel and Google Sheets do not offer XLOOKUP as of 2022.

00:00 Intro
00:46 VLOOKUP flaws
02:34 VLOOKUP example
05:31 MATCH formula
07:09 INDEX formula
08:06 INDEX MATCH combined
09:36 Compare INDEX MATCH to VLOOKUP
10:38 Conclusion

Photo credit: https://www.pexels.com/@italo-melo-881954?utm_content=attributionCopyText&utm_medium=referral&utm_source=pexels