Home › HLOOKUP
HLOOKUP in every language
| Language | Name | Syntax | LibreOffice | Sheets |
|---|---|---|---|---|
| English | HLOOKUP | HLOOKUP(lookup_value, table_array, row_index_num, [range_lookup]) | — | — |
| German | WVERWEIS | WVERWEIS(Suchkriterium; Matrix; Zeilenindex; [Bereich_Verweis]) | WVERWEIS | WVERWEIS |
| French | RECHERCHEH | RECHERCHEH(valeur_cherchée; table_matrice; no_index_col; [valeur_proche]) | RECHERCHEH | RECHERCHEH |
| Spanish | BUSCARH | BUSCARH(valor_buscado; matriz_buscar_en; indicador_filas; [ordenado]) | BUSCARH | BUSCARH |
| Portuguese (Brazil) | PROCH | PROCH(valor_procurado; matriz_tabela; núm_índice_linha; [procurar_intervalo]) | PROCH | PROCH |
| Dutch | HORIZ.ZOEKEN | HORIZ.ZOEKEN(zoekwaarde; tabelmatrix; rij-index_getal; [benaderen]) | HORIZ.ZOEKEN | HORIZ.ZOEKEN |
| Italian | CERCA.ORIZZ | CERCA.ORIZZ(valore; matrice_tabella; indice; [intervallo]) | CERCA.ORIZZ | CERCA.ORIZZ |
Names and arguments from Microsoft Support; the LibreOffice and Google Sheets columns are those products' own localized names. Array-constant separators and localized error values are not yet covered.