{"id":258,"date":"2025-07-15T13:34:46","date_gmt":"2025-07-15T13:34:46","guid":{"rendered":"https:\/\/functiontranslator.com\/2021\/02\/12\/indirect\/"},"modified":"2021-02-13T11:34:39","modified_gmt":"2021-02-13T11:34:39","slug":"indirect","status":"publish","type":"post","link":"https:\/\/functiontranslator.com\/en\/indirect\/","title":{"rendered":"INDIRECT"},"content":{"rendered":"

Welcome to this detailed guide on using the INDIRECT function in both Microsoft Excel and Google Sheets. The INDIRECT function is extremely useful for referring indirectly to cells in a spreadsheet. It is especially helpful when dealing with cell or cell range references defined by text strings.<\/p>\n

Basic Syntax<\/h2>\n

The syntax for the INDIRECT function is as follows:<\/p>\n

=INDIRECT(ref_text, [a1])<\/code><\/pre>\n
    \n
  • ref_text<\/code>: This mandatory argument specifies the cell reference as a text string, which can either be a straightforward cell address like “A1” or a named range.<\/li>\n
  • [a1]<\/code>: This optional argument determines the style of the reference. If set to TRUE<\/code> or omitted, the A1 reference style is used, where columns are labeled with letters and rows with numbers. If FALSE<\/code>, it uses R1C1 reference style, where both columns and rows are labeled numerically.<\/li>\n<\/ul>\n
    Dynamic Referencing<\/h2>\n
    One prevalent use of the INDIRECT function is dynamic cell referencing. Suppose you have a dropdown menu listing column headers and you need to fetch data from a selected column dynamically. The INDIRECT function facilitates this seamlessly.<\/p>\n\n\n\n\n
    A<\/th>\nB<\/th>\nC<\/th>\n<\/tr>\n
    Header 1<\/td>\nHeader 2<\/td>\nHeader 3<\/td>\n<\/tr>\n
    100<\/td>\n200<\/td>\n300<\/td>\n<\/tr>\n<\/table>\n
    Example:<\/strong> If cell E1<\/code> contains the letter “B”, you can utilize the following formula to fetch the value from cell B2<\/code>:<\/p>\n
    =INDIRECT(E1 & \"2\")<\/code><\/pre>\n
    This formula indirectly references cell B2<\/code> and displays the value 200<\/code>.<\/p>\n
    Sum of a Range<\/h2>\n
    The INDIRECT function also proves effective in calculating the sum of a range based on user input or certain conditions.<\/p>\n\n\n\n
    A<\/th>\nB<\/th>\nC<\/th>\n<\/tr>\n
    10<\/td>\n20<\/td>\n30<\/td>\n<\/tr>\n<\/table>\n
    Example:<\/strong> If cell E1<\/code> contains the text “A:C”, you can use the following formula to calculate the sum of the range A1:C1<\/code>:<\/p>\n
    =SUM(INDIRECT(E1))<\/code><\/pre>\n
    This formula will indirectly reference the range A1:C1<\/code> and return the total 60<\/code>.<\/p>\n
    These examples illustrate just a fraction of the potential applications for the INDIRECT function in enhancing the dynamics and flexibility of formulas in your Excel and Google Sheets documents. Explore various scenarios to fully exploit the capabilities of this function!<\/p>\n","protected":false},"excerpt":{"rendered":"
    Returns a reference indicated by a text value<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[200],"tags":[],"class_list":["post-258","post","type-post","status-publish","format-standard","hentry","category-lookup-and-reference"],"acf":[],"yoast_head":"\nExcel INDIRECT Function \u2013 How It Works, Formula Examples and Syntax<\/title>\n<meta name=\"description\" content=\"Learn what the Excel INDIRECT function does. Clear syntax explanation and useful formula examples.\" \/>\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\/en\/indirect\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Excel INDIRECT Function \u2013 How It Works, Formula Examples and Syntax\" \/>\n<meta property=\"og:description\" content=\"Learn what the Excel INDIRECT function does. Clear syntax explanation and useful formula examples.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/functiontranslator.com\/en\/indirect\/\" \/>\n<meta property=\"og:site_name\" content=\"Function Translator\" \/>\n<meta property=\"article:published_time\" content=\"2025-07-15T13:34:46+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2021-02-13T11:34:39+00:00\" \/>\n<meta name=\"author\" content=\"glavadmin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:title\" content=\"Excel INDIRECT Function \u2013 How It Works, Formula Examples and Syntax\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"glavadmin\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\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\/en\/indirect\/\",\"url\":\"https:\/\/functiontranslator.com\/en\/indirect\/\",\"name\":\"Excel INDIRECT Function \u2013 How It Works, Formula Examples and Syntax\",\"isPartOf\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#website\"},\"datePublished\":\"2025-07-15T13:34:46+00:00\",\"dateModified\":\"2021-02-13T11:34:39+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Learn what the Excel INDIRECT function does. Clear syntax explanation and useful formula examples.\",\"breadcrumb\":{\"@id\":\"https:\/\/functiontranslator.com\/en\/indirect\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/en\/indirect\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/en\/indirect\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Function Excel\",\"item\":\"https:\/\/functiontranslator.com\/en\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Lookup and reference\",\"item\":\"https:\/\/functiontranslator.com\/en\/lookup-and-reference\/\"},{\"@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\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\",\"name\":\"glavadmin\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@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\/en\/author\/glavadmin\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Excel INDIRECT Function \u2013 How It Works, Formula Examples and Syntax","description":"Learn what the Excel INDIRECT function does. Clear syntax explanation and useful formula examples.","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\/en\/indirect\/","og_locale":"en_US","og_type":"article","og_title":"Excel INDIRECT Function \u2013 How It Works, Formula Examples and Syntax","og_description":"Learn what the Excel INDIRECT function does. Clear syntax explanation and useful formula examples.","og_url":"https:\/\/functiontranslator.com\/en\/indirect\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:46+00:00","article_modified_time":"2021-02-13T11:34:39+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Excel INDIRECT Function \u2013 How It Works, Formula Examples and Syntax","twitter_misc":{"Written by":"glavadmin","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/functiontranslator.com\/en\/indirect\/","url":"https:\/\/functiontranslator.com\/en\/indirect\/","name":"Excel INDIRECT Function \u2013 How It Works, Formula Examples and Syntax","isPartOf":{"@id":"https:\/\/functiontranslator.com\/no\/#website"},"datePublished":"2025-07-15T13:34:46+00:00","dateModified":"2021-02-13T11:34:39+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Learn what the Excel INDIRECT function does. Clear syntax explanation and useful formula examples.","breadcrumb":{"@id":"https:\/\/functiontranslator.com\/en\/indirect\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/en\/indirect\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/en\/indirect\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Function Excel","item":"https:\/\/functiontranslator.com\/en\/"},{"@type":"ListItem","position":2,"name":"Lookup and reference","item":"https:\/\/functiontranslator.com\/en\/lookup-and-reference\/"},{"@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":"en-US"},{"@type":"Person","@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389","name":"glavadmin","image":{"@type":"ImageObject","inLanguage":"en-US","@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\/en\/author\/glavadmin\/"}]}},"_links":{"self":[{"href":"https:\/\/functiontranslator.com\/en\/wp-json\/wp\/v2\/posts\/258","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/functiontranslator.com\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/functiontranslator.com\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/functiontranslator.com\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/functiontranslator.com\/en\/wp-json\/wp\/v2\/comments?post=258"}],"version-history":[{"count":3,"href":"https:\/\/functiontranslator.com\/en\/wp-json\/wp\/v2\/posts\/258\/revisions"}],"predecessor-version":[{"id":3149,"href":"https:\/\/functiontranslator.com\/en\/wp-json\/wp\/v2\/posts\/258\/revisions\/3149"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/en\/wp-json\/wp\/v2\/media?parent=258"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/en\/wp-json\/wp\/v2\/categories?post=258"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/en\/wp-json\/wp\/v2\/tags?post=258"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}