VLOOKUP = PROCV = BUSCARV = RECHERCHEV = SVERWEIS. Translate a whole formula, separators included, between 6 languages.
Found a formula in an English tutorial but your Excel is in Portuguese, Spanish, French, German or Italian? Paste it here. We swap the function names and the separators (, → ; and 1.5 → 1,5), which is why copied formulas usually fail.
Sheet names and cell references are not translated. Google Sheets accepts English function names in any language, but uses your locale's separators.
The 55 functions small businesses use most. Search in any language.
| English | Português (PT) | Español | Français | Deutsch | Italiano | What it does |
|---|
Names are for Microsoft Excel desktop and Excel for the web. Portuguese is the Portugal version (Brazil differs for a few names, e.g. UNIQUE). Spotted a wrong name? Email us and we fix it the same day.
Broken formulas, a lookup that won't work, a messy export to clean, a simple invoice or stock template. Fixed price after we see the file. 48h.
Send your file for a quoteThis table as a printable 2-page PDF in 6 languages, plus an .xlsx with 20 small-business exercises (VAT, invoices, stock, dates) and answers. Pay once on Gumroad, not on this site.
Buy the Excel cheat sheet ($5)
Opens the Gumroad product page ($5, one-time). Questions: dayinportugal@gmail.com.
Privacy. This page does not send or store anything. If you buy, you pay on Gumroad (portugaldiary.gumroad.com), under Gumroad’s checkout and privacy terms. For questions about the product, contact Pedro Carvalho (Netmend), dayinportugal@gmail.com. You can complain to the Portuguese data protection authority (CNPD).
PROCV (Portugal and Brazil). In Spanish BUSCARV, French RECHERCHEV, German SVERWEIS, Italian CERCA.VERT.
Usually the separator: English Excel uses commas between arguments, most European Excel versions use semicolons, and a decimal comma. The translator fixes both.
Only by changing Excel's display/editing language in Office settings. Many people prefer to keep their language and translate the formula instead.
Each page is a proper reference: what the function does, the syntax and a worked example in English, Portuguese, Spanish, French, German and Italian, plus the mistakes that usually produce a quiet wrong number.