Sign up for our Excel webinar, times added weekly: https://www.excelcampus.com/blueprint...
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:

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 prevent it.

The new XLOOKUP function is another alternative to VLOOKUP and INDEX MATCH. Check out my other videos for more details on that.

VLOOKUP Explained:    • Excel Vlookup Tutorial - Everything Y...  
XLOOKUP Explained:    • Xlookup In Excel: Explained In 3 Minutes  
XLOOKUP Explained in 3 Minutes:    • Xlookup In Excel: Explained In 3 Minutes  
Excel Tables for Beginners:    • Excel Tables Tutorial: Beginners Guid...  

#MsExcel #ExcelCampus
00:00 Introduction
00:39 Benefits of Index Match
02:23 Match Function
06:02 Index Function
09:09 Index Match
12:20 Index Match to the Left
15:13 Most Common Error