Netmend

Netmend · Excel functions · VLOOKUP = PROCV

VLOOKUP in Portuguese = PROCV

VLOOKUP = PROCV = BUSCARV = RECHERCHEV = SVERWEIS = CERCA.VERT. Looks up a value in the first column of a range and returns a value from a column to its right.

6 languagesSyntax + exampleFixes , vs ;Free translator

What VLOOKUP does

It is still the lookup most tutorials teach, and the name everyone searches: PROCV, BUSCARV, RECHERCHEV, SVERWEIS, CERCA.VERT.

Looks up a value in the first column of a range and returns a value from a column to its right.

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 — VLOOKUP
=VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup])
=VLOOKUP(A2,Prices!A:C,3,FALSE)
Português (PT) — PROCV
=PROCV(lookup_value; table_array; col_index_num; [range_lookup])
=PROCV(A2;Prices!A:C;3;FALSO)
Español — BUSCARV
=BUSCARV(lookup_value; table_array; col_index_num; [range_lookup])
=BUSCARV(A2;Prices!A:C;3;FALSO)
Français — RECHERCHEV
=RECHERCHEV(lookup_value; table_array; col_index_num; [range_lookup])
=RECHERCHEV(A2;Prices!A:C;3;FAUX)
Deutsch — SVERWEIS
=SVERWEIS(lookup_value; table_array; col_index_num; [range_lookup])
=SVERWEIS(A2;Prices!A:C;3;FALSCH)
Italiano — CERCA.VERT
=CERCA.VERT(lookup_value; table_array; col_index_num; [range_lookup])
=CERCA.VERT(A2;Prices!A:C;3;FALSO)

Common mistakes

Translate a formula with VLOOKUP

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 VLOOKUP in Portuguese?

PROCV, in both Portugal and Brazil. Spanish BUSCARV, French RECHERCHEV, German SVERWEIS, Italian CERCA.VERT.

Why do I get the wrong row?

You probably omitted FALSE, so Excel is doing an approximate match on an unsorted first column.

VLOOKUP vs XLOOKUP?

XLOOKUP can look left or right, has a built-in “not found” value, and does not break when you insert columns. Use it if your Excel has it; keep VLOOKUP when you need to share with older Excel.

Related functions

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