Excel / 6 min read
XLOOKUP Formula Examples for Cleaner Lookups
See practical XLOOKUP examples for exact matches, custom fallback values, and left-to-right or right-to-left lookups.
XLOOKUP is a modern replacement for many VLOOKUP tasks. It is easier to read, supports custom not-found results, and does not require the key to be in the first column.
Check this first
- Confirm your Excel version supports XLOOKUP.
- Check that lookup and return arrays are the same height or width.
- Set a not-found value explicitly if blanks are preferable to errors.
- Use exact match first before testing optional match modes.
Working examples
Basic XLOOKUP with custom not-found text
=XLOOKUP(A2, F2:F20, G2:G20, "Not found")Why people switch to XLOOKUP
XLOOKUP removes several pain points from VLOOKUP. You point directly at the lookup array and return array, so the formula is easier to read and less likely to break when columns move.
That makes it especially good for growing workbooks where the layout changes over time.
A better fit for maintainable sheets
If the workbook will be edited by many people, XLOOKUP is usually easier to audit because the return range is explicit. You do not need to remember a column index number that can go stale.
- No leftmost-key restriction.
- Cleaner custom fallback handling.
- More readable than VLOOKUP in many real workbooks.
When not to use it
If the file must work in older Excel versions that do not support XLOOKUP, use a more compatible pattern. Compatibility still matters when a workbook is shared outside your team.