How To: Why INDEX-MATCH Beats VLOOKUP

This video demonstrates how to use the Excel INDEX-MATCH functions as a substitute for the VLOOKUP function. Four advantages of using INDEX-MATCH are also covered.
Spreadsheet Geek video on VLOOKUPS: • How To: Use the VLOOK...

[@thelz7909]

Aah, the match function nested within an index function. The technique that has saved me possibly thousands of hours over the past decade or so.