About this tutorial:
Video duration: 00:19:28
In this video I explain how to use the INDEX MATCH formula as an alternative to VLOOKUP in Excel. Download the Excel file:
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:
The ability to return a value from a column to the left/above.
Separate columns for the lookup and return ranges.
We also look at the most common error that the formula returns and how to…