VLOOKUP vs XLOOKUP: Interactive Guide
Try both lookups on a live example table and see exactly when each one breaks.
How to use
- Pick a code and a column to see both formulas and their results.
- Tick “Insert a new column B” to see the classic VLOOKUP mistake.
FAQ
Does Google Sheets have XLOOKUP?
Yes, since 2022.