MATCH in English and Spanish
| English Excel | Spanish Excel | |
|---|---|---|
| Function name | MATCH | COINCIDIR |
| Syntax | =MATCH(lookup_value, lookup_array, [match_type]) | =COINCIDIR(lookup_value; lookup_array; [match_type]) |
| Example | =MATCH("Ana",A1:A20,0) | =COINCIDIR("Ana";A1:A20;0) |
Argument names are shown in English for reference. Spanish examples use the semicolon setting.
What MATCH does
Returns the position of a value within a range. Example: Returns where Ana appears in A1:A20.
Semicolons, commas and decimals
Spanish versions of Excel separate arguments with a semicolon or a comma depending on the regional settings of the computer. With semicolons, decimals are written with a comma (3,14). With commas, decimals use a point (3.14). FormulaCheck converts both.
A common mistake
Use 0 as the last argument for an exact match. The default expects sorted data.
Have a formula to translate or check?
Open FormulaCheckQuestions
Why does my Spanish Excel use semicolons?
Spanish versions of Excel separate arguments with a semicolon or a comma depending on the regional settings of the computer. With semicolons, decimals are written with a comma (3,14). With commas, decimals use a point (3.14). FormulaCheck converts both.
What is a common mistake with MATCH?
Use 0 as the last argument for an exact match. The default expects sorted data.