Formula guide · Excel primarily, with Google Sheets notes · Updated May 13, 2026
XLOOKUP vs VLOOKUP
Compare XLOOKUP and VLOOKUP so you can choose the safer lookup formula for your spreadsheet.
Quick Answer
Use XLOOKUP for new Excel files when available. Use VLOOKUP only when compatibility with older spreadsheets matters.
Copyable Formula
=XLOOKUP(E2,A2:A8,C2:C8,"Not found")Syntax
XLOOKUP is usually =XLOOKUP(value, lookup_range, return_range); VLOOKUP is =VLOOKUP(value, table, column_number, FALSE).Excel primarily, with Google Sheets notes
Worked Example
| Need | Better choice | Why |
|---|---|---|
| Exact match by default | XLOOKUP | Less risk |
| Old workbook compatibility | VLOOKUP | More widely supported |
| Look left | XLOOKUP | No table rearranging |
Result: XLOOKUP is cleaner for most modern lookup tasks; VLOOKUP remains useful in legacy files.
Steps
- Check whether every user opening the file has XLOOKUP.
- Use XLOOKUP when your return column might move.
- Keep VLOOKUP if the workbook must work in older Excel environments.
Common Mistakes
- Replacing every VLOOKUP without checking workbook compatibility.
- Assuming VLOOKUP is exact match by default.
- Using XLOOKUP where a simple table filter would be clearer.
Excel vs Google Sheets Notes
The core idea works in both Excel and Google Sheets, but separators, function availability, and array behavior can vary by account, locale, and version.
Editorial check: This guide was last updated May 13, 2026. Formula behavior can vary by Excel version, Google Sheets rollout, and spreadsheet locale.