Home › XLOOKUP
XLOOKUP in every language
| Language | Name | Syntax | LibreOffice | Sheets |
|---|---|---|---|---|
| English | XLOOKUP | XLOOKUP(lookup_value, lookup_array, return_array, [if_not_found], [match_mode], [search_mode]) | — | — |
| German | XVERWEIS | XVERWEIS(Suchkriterium; Suchmatrix; Rückgabematrix; [wenn_nicht_gefunden]; [Vergleichsmodus]; [Suchmodus]) | XVERWEIS | XVERWEIS |
| French | RECHERCHEX | RECHERCHEX(valeur_cherchée; tableau_recherche; tableau_renvoyé; [si_non_trouvé]; [mode_correspondance]; [mode_recherche]) | RECHERCHEX | XLOOKUP |
| Spanish | BUSCARX | BUSCARX(valor_buscado; matriz_buscada; matriz_devuelta; [si_no_se_encuentra]; [modo_de_coincidencia]; [modo_de_búsqueda]) | BUSCARX | XLOOKUP |
| Portuguese (Brazil) | PROCX | PROCX(pesquisa_valor; pesquisa_matriz; matriz_retorno; [se_não_encontrada]; [modo_correspondência]; [modo_pesquisa]) | PROCX | XLOOKUP |
| Dutch | X.ZOEKEN | X.ZOEKEN(zoekwaarde; zoeken-matrix; matrix_retourneren; [indien_niet_gevonden]; [overeenkomstmodus]; [zoekmodus]) | X.ZOEKEN | XLOOKUP |
| Italian | CERCA.X | CERCA.X(valore; matrice_ricerca; matrice_restituita; [se_non_trovato]; [modalità_confronto]; [modalità_ricerca]) | CERCA.X | CERCA.X |
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.