{"id":6654,"date":"2025-07-15T13:34:48","date_gmt":"2025-07-15T13:34:48","guid":{"rendered":"https:\/\/functiontranslator.com\/equiv\/"},"modified":"2021-02-26T08:10:04","modified_gmt":"2021-02-26T08:10:04","slug":"match","status":"publish","type":"post","link":"https:\/\/functiontranslator.com\/fr\/match\/","title":{"rendered":"EQUIV"},"content":{"rendered":"

La fonction EQUIV (MATCH en anglais) est essentielle dans Excel et Google Sheets pour trouver la position d’un \u00e9l\u00e9ment dans une plage de cellules. Elle peut \u00eatre employ\u00e9e seule ou en combinaison avec d’autres fonctions pour effectuer des recherches avanc\u00e9es et manipuler des donn\u00e9es.<\/p>\n

Syntaxe et exemples<\/h2>\n

Voici la syntaxe de la fonction EQUIV :<\/p>\n

EQUIV(valeur_cherch\u00e9e, plage, [type_correspondance])<\/code><\/pre>\n
    \n
  • valeur_cherch\u00e9e<\/strong> : La valeur que vous recherchez dans la plage.<\/li>\n
  • plage<\/strong> : Les cellules o\u00f9 la recherche est effectu\u00e9e.<\/li>\n
  • type_correspondance<\/strong> (facultatif) : Un chiffre d\u00e9terminant le mode de recherche. Utilisez 0 pour une correspondance exacte, 1 pour une correspondance avec la valeur exacte ou imm\u00e9diatement inf\u00e9rieure, et -1 pour une correspondance avec la valeur exacte ou imm\u00e9diatement sup\u00e9rieure.<\/li>\n<\/ul>\n
    Un exemple d’utilisation de la fonction EQUIV :<\/p>\n
    =EQUIV(3, A1:A5, 0)<\/code><\/pre>\n
    Si la plage A1:A5 contient les valeurs [2, 3, 5, 7, 11], alors cette formule renverra 2, car le nombre 3 est le deuxi\u00e8me \u00e9l\u00e9ment de la liste.<\/p>\n
    Applications pratiques<\/h2>\n
    Voici deux exemples o\u00f9 la fonction EQUIV trouve son utilit\u00e9.<\/p>\n
    Recherche de la position d’un employ\u00e9 dans une liste<\/h2>\n
    Si vous poss\u00e9dez une liste d’employ\u00e9s class\u00e9s par date d’entr\u00e9e dans l’entreprise et souhaitez localiser la position d’un employ\u00e9 sp\u00e9cifique, vous pourriez utiliser EQUIV ainsi :<\/p>\n
    =EQUIV(\"Jean Dupont\", A1:A100, 0)<\/code><\/pre>\n
    Si \u00ab\u00a0Jean Dupont\u00a0\u00bb est localis\u00e9 \u00e0 la cellule A45, la formule renvoie 45. Cette position peut \u00eatre utilis\u00e9e pour acc\u00e9der \u00e0 des informations compl\u00e9mentaires dans d’autres colonnes.<\/p>\n
    Combinaison avec la fonction INDEX pour l’extraction de donn\u00e9es<\/h2>\n
    Associer les fonctions INDEX et EQUIV peut s’av\u00e9rer tr\u00e8s efficace pour extraire des donn\u00e9es sp\u00e9cifiques. Par exemple, pour retrouver le salaire d’un employ\u00e9 \u00e0 partir de son nom :<\/p>\n
    =INDEX(B1:B100, EQUIV(\"Claire Martin\", A1:A100, 0))<\/code><\/pre>\n
    Si Claire Martin est list\u00e9e en 30\u00e8me position et que son salaire figure dans la colonne B, cette formule affichera directement son salaire.<\/p>\n","protected":false},"excerpt":{"rendered":"
    RecheRche des valeuRs dans une R\u00e9f\u00e9Rence ou une matRice<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[312],"tags":[],"class_list":["post-6654","post","type-post","status-publish","format-standard","hentry","category-recherche-et-matrices"],"acf":[],"yoast_head":"\nFonction MATCH (EQUIV) dans Excel : comment \u00e7a marche, exemples et syntaxe<\/title>\n<meta name=\"description\" content=\"Pr\u00e9sentation de la fonction MATCH (EQUIV) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/functiontranslator.com\/fr\/match\/\" \/>\n<meta property=\"og:locale\" content=\"fr_FR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Fonction MATCH (EQUIV) dans Excel : comment \u00e7a marche, exemples et syntaxe\" \/>\n<meta property=\"og:description\" content=\"Pr\u00e9sentation de la fonction MATCH (EQUIV) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/functiontranslator.com\/fr\/match\/\" \/>\n<meta property=\"og:site_name\" content=\"Function Translator\" \/>\n<meta property=\"article:published_time\" content=\"2025-07-15T13:34:48+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2021-02-26T08:10:04+00:00\" \/>\n<meta name=\"author\" content=\"glavadmin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:title\" content=\"Fonction MATCH (EQUIV) dans Excel : comment \u00e7a marche, exemples et syntaxe\" \/>\n<meta name=\"twitter:label1\" content=\"\u00c9crit par\" \/>\n\t<meta name=\"twitter:data1\" content=\"glavadmin\" \/>\n\t<meta name=\"twitter:label2\" content=\"Dur\u00e9e de lecture estim\u00e9e\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/functiontranslator.com\/fr\/match\/\",\"url\":\"https:\/\/functiontranslator.com\/fr\/match\/\",\"name\":\"Fonction MATCH (EQUIV) dans Excel : comment \u00e7a marche, exemples et syntaxe\",\"isPartOf\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#website\"},\"datePublished\":\"2025-07-15T13:34:48+00:00\",\"dateModified\":\"2021-02-26T08:10:04+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Pr\u00e9sentation de la fonction MATCH (EQUIV) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.\",\"breadcrumb\":{\"@id\":\"https:\/\/functiontranslator.com\/fr\/match\/#breadcrumb\"},\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/fr\/match\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/fr\/match\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Fonctions Excel\",\"item\":\"https:\/\/functiontranslator.com\/fr\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Recherche et matrices\",\"item\":\"https:\/\/functiontranslator.com\/fr\/recherche-et-matrices\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"EQUIV\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/functiontranslator.com\/no\/#website\",\"url\":\"https:\/\/functiontranslator.com\/no\/\",\"name\":\"Function Translator\",\"description\":\"Excel function translator\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/functiontranslator.com\/no\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"fr-FR\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\",\"name\":\"glavadmin\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"fr-FR\",\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/03ccd9347c5339db75deede5a8c5b2bf1d40e0bce26a5251fcaac6331d381db8?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/03ccd9347c5339db75deede5a8c5b2bf1d40e0bce26a5251fcaac6331d381db8?s=96&d=mm&r=g\",\"caption\":\"glavadmin\"},\"sameAs\":[\"https:\/\/functiontranslator.com\"],\"url\":\"https:\/\/functiontranslator.com\/fr\/author\/glavadmin\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Fonction MATCH (EQUIV) dans Excel : comment \u00e7a marche, exemples et syntaxe","description":"Pr\u00e9sentation de la fonction MATCH (EQUIV) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/functiontranslator.com\/fr\/match\/","og_locale":"fr_FR","og_type":"article","og_title":"Fonction MATCH (EQUIV) dans Excel : comment \u00e7a marche, exemples et syntaxe","og_description":"Pr\u00e9sentation de la fonction MATCH (EQUIV) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.","og_url":"https:\/\/functiontranslator.com\/fr\/match\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:48+00:00","article_modified_time":"2021-02-26T08:10:04+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Fonction MATCH (EQUIV) dans Excel : comment \u00e7a marche, exemples et syntaxe","twitter_misc":{"\u00c9crit par":"glavadmin","Dur\u00e9e de lecture estim\u00e9e":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/functiontranslator.com\/fr\/match\/","url":"https:\/\/functiontranslator.com\/fr\/match\/","name":"Fonction MATCH (EQUIV) dans Excel : comment \u00e7a marche, exemples et syntaxe","isPartOf":{"@id":"https:\/\/functiontranslator.com\/no\/#website"},"datePublished":"2025-07-15T13:34:48+00:00","dateModified":"2021-02-26T08:10:04+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Pr\u00e9sentation de la fonction MATCH (EQUIV) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.","breadcrumb":{"@id":"https:\/\/functiontranslator.com\/fr\/match\/#breadcrumb"},"inLanguage":"fr-FR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/fr\/match\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/fr\/match\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Fonctions Excel","item":"https:\/\/functiontranslator.com\/fr\/"},{"@type":"ListItem","position":2,"name":"Recherche et matrices","item":"https:\/\/functiontranslator.com\/fr\/recherche-et-matrices\/"},{"@type":"ListItem","position":3,"name":"EQUIV"}]},{"@type":"WebSite","@id":"https:\/\/functiontranslator.com\/no\/#website","url":"https:\/\/functiontranslator.com\/no\/","name":"Function Translator","description":"Excel function translator","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/functiontranslator.com\/no\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"fr-FR"},{"@type":"Person","@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389","name":"glavadmin","image":{"@type":"ImageObject","inLanguage":"fr-FR","@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/03ccd9347c5339db75deede5a8c5b2bf1d40e0bce26a5251fcaac6331d381db8?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/03ccd9347c5339db75deede5a8c5b2bf1d40e0bce26a5251fcaac6331d381db8?s=96&d=mm&r=g","caption":"glavadmin"},"sameAs":["https:\/\/functiontranslator.com"],"url":"https:\/\/functiontranslator.com\/fr\/author\/glavadmin\/"}]}},"_links":{"self":[{"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts\/6654","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/comments?post=6654"}],"version-history":[{"count":2,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts\/6654\/revisions"}],"predecessor-version":[{"id":29665,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts\/6654\/revisions\/29665"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/media?parent=6654"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/categories?post=6654"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/tags?post=6654"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}