HLOOKUP in English and Spanish
| English Excel | Spanish Excel | |
|---|---|---|
| Function name | HLOOKUP | BUSCARH |
| Syntax | =HLOOKUP(lookup_value, table_array, row_index_num, [range_lookup]) | =BUSCARH(lookup_value; table_array; row_index_num; [range_lookup]) |
| Example | =HLOOKUP("Total",A1:F5,3,FALSE) | =BUSCARH("Total";A1:F5;3;FALSO) |
Argument names are shown in English for reference. Spanish examples use the semicolon setting.
What HLOOKUP does
Like VLOOKUP, but searches across the top row. Example: Finds Total in the first row and returns the value three rows down.
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
As with VLOOKUP, use FALSE as the last argument for an exact match.
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 HLOOKUP?
As with VLOOKUP, use FALSE as the last argument for an exact match.