How the modern XLOOKUP function is named across languages, and how it differs from VLOOKUP localization.
XLOOKUP is the modern replacement for VLOOKUP — it searches in any direction, returns multiple values and handles missing matches natively. Like every function, its name is localized, but it follows a neat, consistent pattern across languages.
| Language | XLOOKUP | Compare: VLOOKUP |
|---|---|---|
| English | XLOOKUP | VLOOKUP |
| German | XVERWEIS | SVERWEIS |
| French | RECHERCHEX | RECHERCHEV |
| Spanish | BUSCARX | BUSCARV |
| Italian | CERCA.X | CERCA.VERT |
| Portuguese | PROCX | PROCV |
| Dutch | X.ZOEKEN | VERT.ZOEKEN |
| Polish | X.WYSZUKAJ | WYSZUKAJ.PIONOWO |
| Russian | ПРОСМОТРX | ВПР |
Each language kept its lookup word and simply attached an X: German SVERWEIS → XVERWEIS, French RECHERCHEV → RECHERCHEX, Spanish BUSCARV → BUSCARX. So if you know the VLOOKUP name in a language, the XLOOKUP name is usually one letter away.
Unlike VLOOKUP, XLOOKUP is only available in Microsoft 365 and Excel 2021 (and Excel for the web). If you send an XLOOKUP formula to someone on Excel 2019 or earlier, they'll see a #NAME? error — not because of language, but because their Excel doesn't have the function at all. Check the XLOOKUP function page for its version availability.
Paste it into the formula translator to switch the name and separators between languages. And if a colleague can't use XLOOKUP at all, you may need to fall back to VLOOKUP or INDEX/MATCH for compatibility.