VLOOKUP in English and Spanish
| English Excel | Spanish Excel | |
|---|---|---|
| Function name | VLOOKUP | BUSCARV |
| Syntax | =VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup]) | =BUSCARV(lookup_value; table_array; col_index_num; [range_lookup]) |
| Example | =VLOOKUP(A2,Prices!A:C,3,FALSE) | =BUSCARV(A2;Prices!A:C;3;FALSO) |
Argument names are shown in English for reference. Spanish examples use the semicolon setting.
What VLOOKUP does
Looks up a value in the first column of a table and returns a value from another column. Example: Finds A2 in column A of the Prices sheet and returns the value from the third column.
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
If you omit the last argument (FALSE), Excel uses approximate match, which gives wrong results on unsorted 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 VLOOKUP?
If you omit the last argument (FALSE), Excel uses approximate match, which gives wrong results on unsorted data.