Netmend

Netmend · Excel functions · MATCH = CORRESP

MATCH in Portuguese = CORRESP

MATCH = CORRESP = COINCIDIR = EQUIV = VERGLEICH = CONFRONTA. Returns the position of a value in a range (the row or column number, not the value itself).

6 languagesSyntax + exampleFixes , vs ;Free translator

What MATCH does

It is the engine behind INDEX/MATCH. People search for it under CORRESP, COINCIDIR, EQUIV, VERGLEICH and CONFRONTA.

Returns the position of a value in a range (the row or column number, not the value itself).

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 — MATCH
=MATCH(lookup_value, lookup_array, [match_type])
=MATCH(A2,Prices!A:A,0)
Português (PT) — CORRESP
=CORRESP(lookup_value; lookup_array; [match_type])
=CORRESP(A2;Prices!A:A;0)
Español — COINCIDIR
=COINCIDIR(lookup_value; lookup_array; [match_type])
=COINCIDIR(A2;Prices!A:A;0)
Français — EQUIV
=EQUIV(lookup_value; lookup_array; [match_type])
=EQUIV(A2;Prices!A:A;0)
Deutsch — VERGLEICH
=VERGLEICH(lookup_value; lookup_array; [match_type])
=VERGLEICH(A2;Prices!A:A;0)
Italiano — CONFRONTA
=CONFRONTA(lookup_value; lookup_array; [match_type])
=CONFRONTA(A2;Prices!A:A;0)

Common mistakes

Translate a formula with MATCH

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

CORRESP. Spanish COINCIDIR, French EQUIV, German VERGLEICH, Italian CONFRONTA.

Why do I get #N/A?

No exact match (and you used 0), or extra spaces. Try TRIM on both sides, or use XLOOKUP with an if_not_found message.

MATCH vs XMATCH?

XMATCH is the newer version (search last-to-first, built-in not-found). MATCH is the one that works in older Excel.

Related functions

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