Excel INDEX MATCH Made Simple – Lookup like a Pro

In this step-by-step tutorial, learn how to use Index Match in Microsoft Excel to lookup values. We start with how to use the index function. We use the game Battleship as an example to make it easy to understand. The index function returns a value or the reference to a value from within a table or range. Next, we look at how to use the match function. The match function searches for a specified item in a range of cells, and then returns the relative position of that item in the range. We then bring both index and match together to find specific values within an array. We start with a simple example and then we finish with two more advanced examples. We also look at how to set up a simple drop down list to start building an interactive dashboard.

• Additional resources
  • Sample workbook to follow-along: https://1drv.ms/x/s!AmxrofZZlZ-whMguW…
• Timestamps
  • 0:00 Introduction
  • 1:16 Index function
  • 3:31 Match function
  • 5:36 Index & match simple example
  • 8:50 Index & match advanced example 1
  • 11:54 Drop down lists with index match
  • 13:01 Index & match advanced example 2
  • 15:02 Wrap up