Home › VLOOKUP
VLOOKUP in every language
| Language | Name | Syntax | LibreOffice | Sheets |
|---|---|---|---|---|
| English | VLOOKUP | VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup]) | — | — |
| German | SVERWEIS | SVERWEIS(Suchkriterium; Matrix; Spaltenindex; [Bereich_Verweis]) | SVERWEIS | SVERWEIS |
| French | RECHERCHEV | RECHERCHEV(valeur_cherchée; table_matrice; no_index_col; [valeur_proche]) | RECHERCHEV | RECHERCHEV |
| Spanish | BUSCARV | BUSCARV(valor_buscado; matriz_buscar_en; indicador_columnas; [ordenado]) | BUSCARV | BUSCARV |
| Portuguese (Brazil) | PROCV | PROCV(valor_procurado; matriz_tabela; núm_índice_coluna; [intervalo_pesquisa]) | PROCV | PROCV |
| Dutch | VERT.ZOEKEN | VERT.ZOEKEN(zoekwaarde; tabelmatrix; kolomindex_getal; [benaderen]) | VERT.ZOEKEN | VERT.ZOEKEN |
| Italian | CERCA.VERT | CERCA.VERT(valore; matrice_tabella; indice; [intervallo]) | CERCA.VERT | CERCA.VERT |
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.