XLOOKUP in English and Spanish
| English Excel | Spanish Excel | |
|---|---|---|
| Function name | XLOOKUP | BUSCARX |
| Syntax | =XLOOKUP(lookup_value, lookup_array, return_array, [if_not_found], [match_mode], [search_mode]) | =BUSCARX(lookup_value; lookup_array; return_array; [if_not_found]; [match_mode]; [search_mode]) |
| Example | =XLOOKUP(A2,B:B,C:C,"Not found") | =BUSCARX(A2;B:B;C:C;"Not found") |
Argument names are shown in English for reference. Spanish examples use the semicolon setting.
What XLOOKUP does
A newer alternative to VLOOKUP that can search in any direction. Example: Finds A2 in column B and returns column C, or Not found.
Semicolons, commas and decimals
Spanish versions of Excel separate arguments with a semicolon or a comma depending on the regional settings of the computer. With semicolons, decimals are written with a comma (3,14). With commas, decimals use a point (3.14). FormulaCheck converts both.
A common mistake
It only exists in newer versions of Excel, so older versions show #NAME?.
Have a formula to translate or check?
Open FormulaCheckQuestions
Why does my Spanish Excel use semicolons?
Spanish versions of Excel separate arguments with a semicolon or a comma depending on the regional settings of the computer. With semicolons, decimals are written with a comma (3,14). With commas, decimals use a point (3.14). FormulaCheck converts both.
What is a common mistake with XLOOKUP?
It only exists in newer versions of Excel, so older versions show #NAME?.