{"id":6614,"date":"2025-07-15T13:34:48","date_gmt":"2025-07-15T13:34:48","guid":{"rendered":"https:\/\/functiontranslator.com\/indirect\/"},"modified":"2021-02-26T08:08:30","modified_gmt":"2021-02-26T08:08:30","slug":"indirect","status":"publish","type":"post","link":"https:\/\/functiontranslator.com\/fr\/indirect\/","title":{"rendered":"INDIRECT"},"content":{"rendered":"

Description de la Fonction<\/h2>\n

La fonction INDIRECT permet de cr\u00e9er une r\u00e9f\u00e9rence de cellule \u00e0 partir d’une cha\u00eene de texte. Elle est particuli\u00e8rement utile pour g\u00e9n\u00e9rer des adresses de cellules de mani\u00e8re dynamique ou pour modifier les r\u00e9f\u00e9rences des cellules dans des formules sans avoir \u00e0 les r\u00e9\u00e9crire.<\/p>\n

Syntaxe de la Fonction<\/h2>\n

La syntaxe de la fonction INDIRECT dans Excel et Google Sheets est la suivante :<\/p>\n

INDIRECT(ref_texte, [mode_A1])<\/code><\/pre>\n
O\u00f9 :<\/p>\n
    \n
  • ref_texte<\/strong> : Correspond \u00e0 la cha\u00eene de texte qui sp\u00e9cifie la cellule ou la plage de cellules r\u00e9f\u00e9renc\u00e9es.<\/li>\n
  • mode_A1<\/strong> (optionnel) : Indique le type de notation de la r\u00e9f\u00e9rence. Si TRUE, la r\u00e9f\u00e9rence est au format A1; si FALSE, elle est en notation L1C1. La valeur par d\u00e9faut est TRUE.<\/li>\n<\/ul>\n
    Exemples<\/h2>\n
    Voici quelques exemples illustrant l’utilisation de la fonction INDIRECT.<\/p>\n\n\n\n\n\n
    Formule<\/th>\nDescription<\/th>\nR\u00e9sultat<\/th>\n<\/tr>\n
    =INDIRECT(\"A1\")<\/code><\/td>\nRenvoie la valeur contenue dans la cellule A1.<\/td>\nLa valeur en A1<\/td>\n<\/tr>\n
    =INDIRECT(\"A\"&1)<\/code><\/td>\nCr\u00e9e dynamiquement la r\u00e9f\u00e9rence \u00e0 la cellule A1.<\/td>\nLa valeur en A1<\/td>\n<\/tr>\n
    =SOMME(INDIRECT(\"A1:A10\"))<\/code><\/td>\nCalcule la somme des valeurs de la plage A1 \u00e0 A10.<\/td>\nLa somme des valeurs de A1 \u00e0 A10<\/td>\n<\/tr>\n<\/table>\n
    Sc\u00e9narios d’utilisation<\/h2>\n
    Examinons des sc\u00e9narios concrets o\u00f9 la fonction INDIRECT se r\u00e9v\u00e8le tr\u00e8s efficace.<\/p>\n
    Scenario 1: R\u00e9f\u00e9rence Dynamique \u00e0 Une Plage de Cellules<\/h2>\n
    Imaginez une liste de nombres de A1 \u00e0 A10 dont vous souhaitez calculer la somme. Avec INDIRECT, vous pouvez ajuster la plage de sommation en fonction d\u2019une valeur contenue dans une autre cellule.<\/p>\n
    =SOMME(INDIRECT(\"A1:A\" & B1))<\/code><\/pre>\n
    Dans cet exemple, si B1 contient 10, la formule additionnera les valeurs de A1 \u00e0 A10. Si la valeur de B1 change pour 5, elle recalculera pour sommer de A1 \u00e0 A5, ne n\u00e9cessitant aucune modification directe de la formule.<\/p>\n
    Scenario 2: Changement Dynamique de Feuilles de R\u00e9f\u00e9rence<\/h2>\n
    Supposez que vous disposez de donn\u00e9es r\u00e9parties sur plusieurs feuilles nomm\u00e9es Janvier, F\u00e9vrier, Mars, etc. Vous souhaitez faire un r\u00e9sum\u00e9 de ces donn\u00e9es pour un mois sp\u00e9cifique sans r\u00e9\u00e9crire vos formules \u00e0 chaque fois.<\/p>\n
    =SOMME(INDIRECT(C1 & \"!A1:A10\"))<\/code><\/pre>\n
    Dans ce cas, si C1 affiche \u00ab\u00a0F\u00e9vrier\u00a0\u00bb, la formule cumulera les valeurs de A1 \u00e0 A10 de la feuille \u00ab\u00a0F\u00e9vrier\u00a0\u00bb. Modifier C1 permet de r\u00e9sumer les donn\u00e9es d’une autre feuille correspondant \u00e0 un autre mois.<\/p>\n","protected":false},"excerpt":{"rendered":"
    Renvoie une R\u00e9f\u00e9Rence indiqu\u00e9e paR une valeuR de texte<\/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-6614","post","type-post","status-publish","format-standard","hentry","category-recherche-et-matrices"],"acf":[],"yoast_head":"\nFonction INDIRECT dans Excel : comment \u00e7a marche, exemples et syntaxe<\/title>\n<meta name=\"description\" content=\"Pr\u00e9sentation de la fonction INDIRECT 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\/indirect\/\" \/>\n<meta property=\"og:locale\" content=\"fr_FR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Fonction INDIRECT dans Excel : comment \u00e7a marche, exemples et syntaxe\" \/>\n<meta property=\"og:description\" content=\"Pr\u00e9sentation de la fonction INDIRECT d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/functiontranslator.com\/fr\/indirect\/\" \/>\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:08:30+00:00\" \/>\n<meta name=\"author\" content=\"glavadmin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:title\" content=\"Fonction INDIRECT 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\/indirect\/\",\"url\":\"https:\/\/functiontranslator.com\/fr\/indirect\/\",\"name\":\"Fonction INDIRECT 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:08:30+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Pr\u00e9sentation de la fonction INDIRECT d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.\",\"breadcrumb\":{\"@id\":\"https:\/\/functiontranslator.com\/fr\/indirect\/#breadcrumb\"},\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/fr\/indirect\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/fr\/indirect\/#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\":\"INDIRECT\"}]},{\"@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 INDIRECT dans Excel : comment \u00e7a marche, exemples et syntaxe","description":"Pr\u00e9sentation de la fonction INDIRECT 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\/indirect\/","og_locale":"fr_FR","og_type":"article","og_title":"Fonction INDIRECT dans Excel : comment \u00e7a marche, exemples et syntaxe","og_description":"Pr\u00e9sentation de la fonction INDIRECT d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.","og_url":"https:\/\/functiontranslator.com\/fr\/indirect\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:48+00:00","article_modified_time":"2021-02-26T08:08:30+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Fonction INDIRECT 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\/indirect\/","url":"https:\/\/functiontranslator.com\/fr\/indirect\/","name":"Fonction INDIRECT 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:08:30+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Pr\u00e9sentation de la fonction INDIRECT d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.","breadcrumb":{"@id":"https:\/\/functiontranslator.com\/fr\/indirect\/#breadcrumb"},"inLanguage":"fr-FR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/fr\/indirect\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/fr\/indirect\/#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":"INDIRECT"}]},{"@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\/6614","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=6614"}],"version-history":[{"count":2,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts\/6614\/revisions"}],"predecessor-version":[{"id":29625,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts\/6614\/revisions\/29625"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/media?parent=6614"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/categories?post=6614"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/tags?post=6614"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}