Use Index-Match-Match in Excel like a true pro

Hi there, I'm Henry from Eagleheart FP&A. With over 15+ years working in FP&A in Media, Entertainment, & Tech, I help you to learn and grow as a finance professional and Excel expert.

Learn how to use the index-match-match in Excel using three different methods.

Download the file here:
(Search for "Index Match Match template" and click "Download")

0:00 intro
0:25 how to do a basic Index-Match
1:40 how to use Index-Match-Match
3:14 Index-Match-Match with multiple criteria using a helper column
4:26 Index-Match-Match with multiple criteria using an array formula
7:36 Index-Match-Match with multiple criteria using another "index" function in the lookup_array portion

[eagleheartfpa]

Download the file here:
(Search for "Index Match Match template" and click "Download")