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) 

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

Question? Ask it in our Excel Forum


Excel VBA Course

(35% Sale Ends Jan. 26)

Excel VBA Course - From Beginner to Expert

200+ Video Lessons 50+ Hours of Instruction 200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course (35% Discount)

Tutorial Details
Excel Function: INDEX(), MATCH()
Downloadable Files: Excel File
Excel VBA Course

(35% Sale Ends Jan. 26)

Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course (35% Discount)