Netmend

Netmend · Excel functions · XLOOKUP = PROCX

XLOOKUP in Portuguese = PROCX

XLOOKUP = PROCX = BUSCARX = RECHERCHEX = XVERWEIS = CERCA.X. Looks up a value in one range and returns the matching value from another range, in any direction.

6 languagesSyntax + exampleFixes , vs ;Free translator

What XLOOKUP does

It replaces most VLOOKUP and INDEX/MATCH work, but the name is still new in other languages (PROCX, BUSCARX, RECHERCHEX, XVERWEIS, CERCA.X).

Looks up a value in one range and returns the matching value from another range, in any direction.

Syntax and a worked example in 6 languages

English Excel uses commas between arguments and a dot decimal. Most European Excel versions use semicolons and a decimal comma. TRUE / FALSE also change name. The translator below applies all three.

English — XLOOKUP
=XLOOKUP(lookup_value, lookup_array, return_array, [if_not_found], [match_mode], [search_mode])
=XLOOKUP(A2,Prices!A:A,Prices!C:C,"not found")
Português (PT) — PROCX
=PROCX(lookup_value; lookup_array; return_array; [if_not_found]; [match_mode]; [search_mode])
=PROCX(A2;Prices!A:A;Prices!C:C;"not found")
Español — BUSCARX
=BUSCARX(lookup_value; lookup_array; return_array; [if_not_found]; [match_mode]; [search_mode])
=BUSCARX(A2;Prices!A:A;Prices!C:C;"not found")
Français — RECHERCHEX
=RECHERCHEX(lookup_value; lookup_array; return_array; [if_not_found]; [match_mode]; [search_mode])
=RECHERCHEX(A2;Prices!A:A;Prices!C:C;"not found")
Deutsch — XVERWEIS
=XVERWEIS(lookup_value; lookup_array; return_array; [if_not_found]; [match_mode]; [search_mode])
=XVERWEIS(A2;Prices!A:A;Prices!C:C;"not found")
Italiano — CERCA.X
=CERCA.X(lookup_value; lookup_array; return_array; [if_not_found]; [match_mode]; [search_mode])
=CERCA.X(A2;Prices!A:A;Prices!C:C;"not found")

Common mistakes

Translate a formula with XLOOKUP

Paste any formula. Function names and separators are converted between English, Portuguese, Spanish, French, German and Italian.

Sheet names and cell references are not translated. Google Sheets accepts English function names, but uses your locale’s separators.

Stuck with a spreadsheet? We fix it. From $25

Broken lookups, a running balance that will not stay still, a translated workbook full of #NAME? errors. Fixed price after we see the file. 48h.

Send the sheet

Who handles the data: Pedro Carvalho (Netmend), dayinportugal@gmail.com. Files are used only for the order and deleted after delivery. No address, phone or national ID is asked for or published.

If you just need the function names and 20 practice exercises, the Excel cheat sheet is $5 on Gumroad. Payment is on Gumroad, not on this site.

FAQ

What is XLOOKUP in Portuguese?

PROCX. Spanish BUSCARX, French RECHERCHEX, German XVERWEIS, Italian CERCA.X.

How do I return the last two columns before a Total heading?

Do not hard-code column L. Use MATCH or XMATCH on the header row to find “Total”, then return the two columns to its left, or use a table with structured names.

Can it look to the left?

Yes. The lookup array and the return array are separate, unlike VLOOKUP.

Related functions

Bank statement → CSV · Testimonial wall · Pinterest pin maker · All Netmend services