Stop using VLOOKUP in Excel Switch to INDEX MATCH

Microsoft Excel VLOOKUP function will not get you the results that you need all of the times, because it's limitations.
with this short video you can rid VLOOKUP from your life. Switch to INDEX MATCH to end the tyranny of VLOOKUP forever.

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