ExcelAt40 – Day 11: Lookup Wars – VLOOKUP vs XLOOKUP

Hello Excel fam 👋

Today’s post dives into the differences between VLOOKUP and XLOOKUP — with a visual comparison, practical tips, and even a quiz to test your lookup knowledge.

We also covered how to use XLOOKUP with IFERROR for cleaner formulas and wrapped it all up with a cheat sheet.

Would love to hear:
👉 Are you still using VLOOKUP?

👉 What’s your favorite XLOOKUP trick?