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.