Excel INDEX MATCH Explained (An Alternative to VLOOKUP)

In this video I explain how to use the INDEX MATCH formula as an alternative to VLOOKUP in Excel.  Download the Excel file: https://www.excelcampus.com/functions…

You can follow along with the video and practice writing the formulas.  The Excel file also includes my cheat sheet for writing the formulas.

I explain the two main benefits of INDEX MATCH over VLOOKUP.  This includes:

1. The ability to return a value from a column to the left/above.

2. Separate columns for the lookup and return ranges.

3. We also look at the most common error that the formula returns and how to prevent it.