Home › MATCH
MATCH in every language
| Language | Name | Syntax | LibreOffice | Sheets |
|---|---|---|---|---|
| English | MATCH | MATCH(lookup_value, lookup_array, [match_type]) | — | — |
| German | VERGLEICH | VERGLEICH(Suchkriterium; Suchmatrix; [Vergleichstyp]) | VERGLEICH | VERGLEICH |
| French | EQUIV | EQUIV(valeur_cherchée; matrice_recherche; [type]) | EQUIV | EQUIV |
| Spanish | COINCIDIR | COINCIDIR(valor_buscado; matriz_buscada; [tipo_de_coincidencia]) | COINCIDIR | COINCIDIR |
| Portuguese (Brazil) | CORRESP | CORRESP(valor_procurado; matriz_procurada; [tipo_correspondência]) | CORRESP | CORRESP |
| Dutch | VERGELIJKEN | VERGELIJKEN(zoekwaarde; zoeken_matrix; [criteriumtype_getal]) | VERGELIJKEN | VERGELIJKEN |
| Italian | CONFRONTA | CONFRONTA(valore; matrice; [corrisp]) | CONFRONTA | CONFRONTA |
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.