Excel 365 / 2021+Google SheetsIn Spanish: BUSCARX

XLOOKUP in Excel & Google Sheets

Finds a value in one range and returns the matching value from another. It searches in any direction and lets you choose what to show when nothing is found.

Syntax

=XLOOKUP(lookup_value, lookup_array, return_array, [if_not_found], [match_mode])

Example: Find a price by SKU

Excel / Sheets · English

=XLOOKUP(E2, A2:A6, C2:C6, "Not found")

Excel / Sheets · Español

=BUSCARX(E2; A2:A6; C2:C6; "Not found")

Searches the SKU in column A and returns the price from column C.

XLOOKUP in Spanish

In Spanish Excel and Google Sheets, XLOOKUP is called BUSCARX. It's the same function: files translate automatically when opened in another language. When you type it by hand, the name and the argument separator change.

	English	Spanish
Function	XLOOKUP	BUSCARX
Separator	,	;
Example	=XLOOKUP(E2, A2:A6, C2:C6, "Not found")	=BUSCARX(E2; A2:A6; C2:C6; "Not found")

The separator depends on regional settings: Spanish versions usually use semicolons, but countries with a decimal point (like Mexico) may use commas.

Translate another formula

Arguments

lookup_valueRequiredThe value to search for.

lookup_arrayRequiredThe range or column to search in.

return_arrayRequiredThe range or column to return a value from.

if_not_foundOptionalText to return when there is no match. Default: #N/A.

match_modeOptional0 exact (default), -1 / 1 next smaller / larger, 2 wildcard.

XLOOKUP FAQ

What is XLOOKUP in Spanish?

In Spanish, XLOOKUP is BUSCARX. When you type it by hand in a Spanish Excel, arguments are usually separated by semicolons (;): =BUSCARX(E2; A2:A6; C2:C6; "Not found")

Does XLOOKUP work in Google Sheets?

Yes. XLOOKUP works in Google Sheets with the same syntax as in Excel. In a sheet set to Spanish it's called BUSCARX. The separator (comma or semicolon) follows the sheet's locale, under File → Settings.