{"id":1437,"date":"2018-07-04T14:56:32","date_gmt":"2018-07-04T14:56:32","guid":{"rendered":"http:\/\/officetuts.net\/excel\/?p=1437"},"modified":"2023-11-03T09:08:59","modified_gmt":"2023-11-03T09:08:59","slug":"indirect","status":"publish","type":"post","link":"https:\/\/officetuts.net\/excel\/functions\/indirect\/","title":{"rendered":"INDIRECT function"},"content":{"rendered":"\n

Excel INDIRECT Function is a useful tool for referencing and retrieving data from different cells or ranges within a worksheet. It allows you to create dynamic references by using text values or cell references.<\/p>\n\n\n\n

Syntax<\/h2>\n\n\n\n

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

=INDIRECT(ref_text, [a1])<\/strong><\/p>\n\n\n\n

Arguments<\/h2>\n\n\n\n
ref_text<\/b><\/td>The reference you want to create, either as a text string or a cell reference.<\/td><\/tr>
[a1]<\/b><\/td>(Optional) If set to TRUE or omitted, ref_text is interpreted as an A1-style reference. If set to FALSE, ref_text is treated as an R1C1-style reference.<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n

How to use<\/h2>\n\n\n\n

You can use the INDIRECT function in various ways to create dynamic references. Here are some examples:<\/p>\n\n\n\n

Example 1:<\/strong> Referencing a Cell Using Text<\/p>\n\n\n\n

=INDIRECT(\"A1\")<\/code><\/pre>\n\n\n\n
This formula will return the value from cell A1.<\/p>\n\n\n\n
Example 2:<\/strong> Creating Dynamic Range References<\/p>\n\n\n\n
=INDIRECT(\"Sheet1!A1:A5\")<\/code><\/pre>\n\n\n\n
This formula can be used to reference a range of cells in Sheet1, such as A1 to A5.<\/p>\n\n\n\n
Example 3:<\/strong> Combining with Functions<\/p>\n\n\n\n
=AVERAGE(INDIRECT(\"B1:B5\"))<\/code><\/pre>\n\n\n\n
You can use the INDIRECT function in combination with other functions. In this example, it calculates the average of values in cells B1 to B5.<\/p>\n\n\n\n
Example 4:<\/strong> Using Cell References<\/p>\n\n\n\n
=INDIRECT(A1)<\/code><\/pre>\n\n\n\n
If cell A1 contains the text “B2,” this formula will reference the cell B2.<\/p>\n\n\n\n
Excel INDIRECT is a versatile function that allows you to build dynamic references and work with data more efficiently. It’s particularly useful when you need to create dynamic formulas and interact with different parts of your worksheet.<\/p>\n","protected":false},"excerpt":{"rendered":"
Excel INDIRECT Function is a useful tool for referencing and retrieving data from different cells or ranges within a worksheet. It allows you…<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[25],"tags":[180],"yoast_head":"\nINDIRECT function<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/officetuts.net\/excel\/functions\/indirect\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"INDIRECT function\" \/>\n<meta property=\"og:description\" content=\"Excel INDIRECT Function is a useful tool for referencing and retrieving data from different cells or ranges within a worksheet. It allows you...\" \/>\n<meta property=\"og:url\" content=\"https:\/\/officetuts.net\/excel\/functions\/indirect\/\" \/>\n<meta property=\"article:published_time\" content=\"2018-07-04T14:56:32+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-11-03T09:08:59+00:00\" \/>\n<meta name=\"author\" content=\"Tomasz Decker\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Tomasz Decker\" \/>\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\":\"Article\",\"@id\":\"https:\/\/officetuts.net\/excel\/functions\/indirect\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/officetuts.net\/excel\/functions\/indirect\/\"},\"author\":{\"name\":\"Tomasz Decker\",\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42\"},\"headline\":\"INDIRECT function\",\"datePublished\":\"2018-07-04T14:56:32+00:00\",\"dateModified\":\"2023-11-03T09:08:59+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/officetuts.net\/excel\/functions\/indirect\/\"},\"wordCount\":242,\"publisher\":{\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42\"},\"keywords\":[\"done\"],\"articleSection\":[\"functions\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/officetuts.net\/excel\/functions\/indirect\/\",\"url\":\"https:\/\/officetuts.net\/excel\/functions\/indirect\/\",\"name\":\"INDIRECT function\",\"isPartOf\":{\"@id\":\"https:\/\/officetuts.net\/excel\/#website\"},\"datePublished\":\"2018-07-04T14:56:32+00:00\",\"dateModified\":\"2023-11-03T09:08:59+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/officetuts.net\/excel\/functions\/indirect\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/officetuts.net\/excel\/functions\/indirect\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/officetuts.net\/excel\/functions\/indirect\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/officetuts.net\/excel\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"INDIRECT function\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/officetuts.net\/excel\/#website\",\"url\":\"https:\/\/officetuts.net\/excel\/\",\"name\":\"\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/officetuts.net\/excel\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42\",\"name\":\"Tomasz Decker\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/18cbe22837193574870ae40ba56bf712?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/18cbe22837193574870ae40ba56bf712?s=96&d=mm&r=g\",\"caption\":\"Tomasz Decker\"},\"logo\":{\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/image\/\"},\"description\":\"Spreadsheet and Python enthusiast.\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"INDIRECT function","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:\/\/officetuts.net\/excel\/functions\/indirect\/","og_locale":"en_US","og_type":"article","og_title":"INDIRECT function","og_description":"Excel INDIRECT Function is a useful tool for referencing and retrieving data from different cells or ranges within a worksheet. It allows you...","og_url":"https:\/\/officetuts.net\/excel\/functions\/indirect\/","article_published_time":"2018-07-04T14:56:32+00:00","article_modified_time":"2023-11-03T09:08:59+00:00","author":"Tomasz Decker","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Tomasz Decker","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/officetuts.net\/excel\/functions\/indirect\/#article","isPartOf":{"@id":"https:\/\/officetuts.net\/excel\/functions\/indirect\/"},"author":{"name":"Tomasz Decker","@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42"},"headline":"INDIRECT function","datePublished":"2018-07-04T14:56:32+00:00","dateModified":"2023-11-03T09:08:59+00:00","mainEntityOfPage":{"@id":"https:\/\/officetuts.net\/excel\/functions\/indirect\/"},"wordCount":242,"publisher":{"@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42"},"keywords":["done"],"articleSection":["functions"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/officetuts.net\/excel\/functions\/indirect\/","url":"https:\/\/officetuts.net\/excel\/functions\/indirect\/","name":"INDIRECT function","isPartOf":{"@id":"https:\/\/officetuts.net\/excel\/#website"},"datePublished":"2018-07-04T14:56:32+00:00","dateModified":"2023-11-03T09:08:59+00:00","breadcrumb":{"@id":"https:\/\/officetuts.net\/excel\/functions\/indirect\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/officetuts.net\/excel\/functions\/indirect\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/officetuts.net\/excel\/functions\/indirect\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/officetuts.net\/excel\/"},{"@type":"ListItem","position":2,"name":"INDIRECT function"}]},{"@type":"WebSite","@id":"https:\/\/officetuts.net\/excel\/#website","url":"https:\/\/officetuts.net\/excel\/","name":"","description":"","publisher":{"@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/officetuts.net\/excel\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":["Person","Organization"],"@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42","name":"Tomasz Decker","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/18cbe22837193574870ae40ba56bf712?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/18cbe22837193574870ae40ba56bf712?s=96&d=mm&r=g","caption":"Tomasz Decker"},"logo":{"@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/image\/"},"description":"Spreadsheet and Python enthusiast."}]}},"_links":{"self":[{"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/posts\/1437"}],"collection":[{"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/comments?post=1437"}],"version-history":[{"count":3,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/posts\/1437\/revisions"}],"predecessor-version":[{"id":16422,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/posts\/1437\/revisions\/16422"}],"wp:attachment":[{"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/media?parent=1437"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/categories?post=1437"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/tags?post=1437"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}