Formulas & Functions (VLOOKUP, INDEX-MATCH, XLOOKUP)

Summary

Lookup functions let you pull matching data from another table — VLOOKUP is the classic, INDEX-MATCH is more flexible, and XLOOKUP (in modern Excel) is the simpler, more powerful replacement for both.

• 1Practice the same lookup with all 3 functions on the same dataset.
• 2Learn why VLOOKUP breaks when columns are inserted, and why INDEX-MATCH/XLOOKUP don't.
• 3Memorize XLOOKUP's argument order — it'll be your default once you know it.