← The library
Excel concept
Choosing a lookup function
VLOOKUP looks right only and breaks when columns move; INDEX/MATCH looks anywhere; XLOOKUP does both with exact match by default.
Daily driverDifficulty 1450 · Advanced
The shape of it
- In practice
Default to XLOOKUP where available; INDEX/MATCH for older files; always exact match unless the table is sorted on purpose.
Related
Learn the moves here — or let Wauvel run them on your numbers.
$99/mo, everything included. Free for 14 days, no card.
One CFO-grade Excel tip a week
A short, practical email for finance operators — functions, shortcuts, and the moves that save an afternoon. Free, unsubscribe anytime.