How to Use INDEX MATCH Lookups in Excel - Step-by-Step Guide

Add to Favorites
Author: | Edits: don

Step-by-Step guide to using INDEX/MATCH to create the most versatile and robust lookup formula in Excel.

After this tutorial, you will never want to use a Vlookup again!

I cover every step of creating the Index/Match lookup formula so that you have the skills and information you need to create a lookup for your own situation and data set.

This tutorial also includes 3 separate lookup examples:

  • Vertical lookup using Index/Match
  • Horizontal lookup using Index/Match
  • Double lookup using Index/Match (vertical & horizontal) 

Question? Ask it in our Excel Forum


Excel Function: INDEX(), MATCH()
Downloadable Files: Excel File