Home › XMATCH
XMATCH in every language
| Language | Name | Syntax | LibreOffice | Sheets |
|---|---|---|---|---|
| English | XMATCH | XMATCH(lookup_value, lookup_array, [match_mode], [search_mode]) | — | — |
| German | XVERGLEICH | XVERGLEICH(Suchkriterium; Suchmatrix; [Vergleichsmodus]; [Suchmodus]) | XVERGLEICH | — |
| French | EQUIVX | EQUIVX(valeur_cherchée; tableau_recherche; [mode_correspondance]; [mode_recherche]) | EQUIVX | — |
| Spanish | COINCIDIRX | COINCIDIRX(valor_buscado; matriz_buscada; [modo_de_coincidencia]; [modo_de_búsqueda]) | COINCIDIRX | — |
| Portuguese (Brazil) | CORRESPX | CORRESPX(pesquisa_valor; pesquisa_matriz; [modo_correspondência]; [modo_pesquisa]) | CORRESPX | — |
| Dutch | X.VERGELIJKEN | X.VERGELIJKEN(zoekwaarde; zoeken-matrix; [overeenkomstmodus]; [zoekmodus]) | X.VERGELIJKEN | — |
| Italian | CONFRONTA.X | CONFRONTA.X(valore; matrice; [modalità_confronto]; [modalità_ricerca]) | CONFRONTA.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.