Скачать или смотреть Use Index-Match in Excel like a pro

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

Learn how to use the index-match formula in Excel (and why vlookup is terrible). We'll create a simple Sales Commissions report using index-match, with both match type 0 and match type 1. We will also explore using a row number trick with index-match and take a look at how to use multiple criteria with index-match.

Download the file here:
https://www.eagleheartfpa.com/file-sh...
(Search for "Index-Match Template" and click "Download")

0:00 intro
1:58 use index-match with match type 0
4:40 use index-match with match type 1
8:10 automate index-match using a row number trick
13:35 use multiple criteria in the index-match formula