You are working through a Spanish-language course that uses BUSCARX and FILTRAR, but your English Excel recognises neither. You need the English names before the lesson ends.
How to use Function Names step by step
1. Type the name in any language
Search runs across all three columns at once, so it makes no difference whether you know the English or the local version.
2. Narrow by category if useful
Cut the table down to text, date, lookup, statistical or financial functions to browse close relatives.
3. Copy the exact name
One click on a name copies it. The asterisk flags names Microsoft lists without a real worked example behind them.
The Step Count: Traditional Friction vs. KorexTools
Hunting each equivalent across forums and help pages (4 scattered steps)
- Open a search engine and type the name in one language.
- Land on several forums that contradict each other.
- Try the name in a cell and see whether Excel accepts it.
- Repeat for every function in the course.
With the KorexTools Function Dictionary (3 steps)
- Type the name you know.
- Spot the row with all three versions.
- Copy the local name with one click.
What every Excel function is called in your language, and why a tutorial sometimes disagrees
Microsoft localises function names in each edition of Excel, and rarely word for word: VLOOKUP is BUSCARV in Spanish, TRIM is ESPACIOS, SEARCH is HALLAR, while INDICE and COINCIDIR sit close to INDEX and MATCH. Brazilian Portuguese drifts further still (PROCV, SE, SOMASES). If an English guide tells you to use IFS and your sheet asks for SI.CONJUNTO, nothing is wrong with your install: that is just how the name was localised.
This table starts from Microsoft documentation in all three languages and was cross-checked function by function against each page's worked examples. Where the translated page title disagreed with the name used in its own sample formulas, the sample won; the few names that could not be verified carry an asterisk so you can try them in your install before relying on them.
Getting the most out of the table
- •Search by whichever version you already know: English, Spanish or Portuguese all work.
- •Use the category filter to spot alternatives, such as the family ending in .SI.CONJUNTO in Spanish.
- •To convert whole formulas, run them through the translator in this same suite instead of swapping names by hand.
A few everyday functions
| English | Spanish | Portuguese (BR) |
|---|---|---|
| VLOOKUP | BUSCARV | PROCV |
| IF | SI | SE |
| SUMIFS | SUMAR.SI.CONJUNTO | SOMASES |
Common Mistakes and How to Avoid Them
- ⚠️Typing an English name into a Spanish-language Excel and concluding the function does not exist.
- ⚠️Mixing names from two languages inside one formula.
Frequently Asked Questions
Where do the function names come from?
From Microsoft's official support pages in English, Spanish and Portuguese, checked against the sample formulas shown on each one.
Why do some functions carry an asterisk?
Because the name appears in the documentation but no real example confirms it, which is common with recent functions. Try it in your Excel before using it in a report.
Does it work for Latin American Spanish too?
The table follows Microsoft's Spain-Spanish documentation. Most names match across Latin America, but confirm any you doubt in your own Excel; the separator, which does vary by country, is handled by the translator in this silo.
What I would do if I were in your shoes
«When a function name fails, do not doubt your formula first: check your Excel language with a simple pair such as SUMA and SUM.» — DataKorex Engineering Team.