Home › Excel guides › Italian and Portuguese Excel function names explained

Italian and Portuguese Excel function names explained

Common Italian (CERCA.VERT, SE…) and Portuguese (PROCV, SE…) function names mapped to English.

Italian and Portuguese Excel both translate function names, so formulas from those versions look unfamiliar in English Excel. This reference maps the most common Italian and Portuguese function names to English. For all 522 functions, use the full translation table.

Common Italian → English

ItalianEnglish
SOMMASUM
MEDIAAVERAGE
SEIF
CERCA.VERTVLOOKUP
CERCA.XXLOOKUP
SOMMA.SESUMIF
CONTA.SECOUNTIF
CONFRONTAMATCH
INDICEINDEX
SE.ERROREIFERROR

Common Portuguese → English

PortugueseEnglish
SOMASUM
MÉDIAAVERAGE
SEIF
PROCVVLOOKUP
PROCXXLOOKUP
SOMASESUMIF
CONT.SECOUNTIF
CORRESPMATCH
ÍNDICEINDEX
SEERROIFERROR

Patterns

Convert a whole formula

Paste an Italian or Portuguese formula into the formula translator, set the source language, and it converts the names, separators and constants to English at once.

← All Excel guides

Copied to clipboard