{"id":3344,"date":"2020-08-09T02:50:22","date_gmt":"2020-08-09T00:50:22","guid":{"rendered":"https:\/\/www.myexcelonline.com\/?p=3344"},"modified":"2024-04-06T21:59:55","modified_gmt":"2024-04-06T19:59:55","slug":"excel-indirect-function-using-sheet-references","status":"publish","type":"post","link":"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/excel-indirect-function-using-sheet-references\/","title":{"rendered":"Excel INDIRECT Function Using Sheet References"},"content":{"rendered":"<p>Excel <strong>Indirect<\/strong> function can be used to<strong> return a valid reference<\/strong> from a given text string.<\/p>\n<p>The <strong>cell reference provided in this <a class=\"wpil_keyword_link\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/top-excel-formulas-function-examples-to-get-better-at-microsoft-excel\/\" target=\"_blank\" rel=\"noopener\" title=\"formula\" data-wpil-keyword-link=\"linked\">formula<\/a> will not change<\/strong> when you add or delete rows and\/or columns. For <strong>Example<\/strong>, =INDIRECT(A1: E1) will always refer to the first 5 columns of the sheet even if new columns are added or deleted.<\/p>\n<p>In this article, you will learn in details regarding the following:<\/p>\n<ul>\n<li><a href=\"#excel-indirect-function\"><strong>Excel Indirect Function<\/strong><\/a><\/li>\n<li><a href=\"#basic-use-of-indirect-function\"><strong>Basic use of Indirect Function<\/strong><\/a><\/li>\n<li><a href=\"#reference-a-cell-in-another-sheet\"><strong>Reference A Cell in Another Sheet<\/strong><\/a><\/li>\n<li><a href=\"#reference-a-range-of-cells-in-another-sheet\"><strong>Reference a Range of Cells in Another Sheet<\/strong><\/a><\/li>\n<li><a href=\"#conclusion\"><strong>Conclusion<\/strong><\/a><\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<h3><strong><a id=\"excel-indirect-function\"><\/a>Excel Indirect Function<\/strong><\/h3>\n<p>This function<strong> does not perform any calculation<\/strong> or evaluate any logic or condition.<\/p>\n<p><em><strong>So, What does it do?<\/strong><\/em><\/p>\n<p>Excel Indirect function is used to <strong>indirectly reference<\/strong> a cell, or a range of cells <strong>of a sheet<\/strong>.<\/p>\n<p><em><strong>Formula breakdown:<\/strong><\/em><\/p>\n<p>=INDIRECT(<span style=\"color: #0000ff\">ref_text<\/span>, <span style=\"color: #ff0000\">[a1]<\/span>)<\/p>\n<p><em><strong>What it means:<\/strong><\/em><\/p>\n<p><strong><span style=\"color: #0000ff\">ref_text <\/span><\/strong>&#8211; return the referenced range<\/p>\n<p><strong><span style=\"color: #ff0000\">[a1]<\/span> &#8211;<\/strong> specify the type of reference (A1 style or R1c1 style) mentioned in ref_text.<em> Omit or type TRUE if the reference is an A1 style <strong>or<\/strong> enter FALSE if it is an R1C1 style.<\/em><\/p>\n<p>The type of references are:<\/p>\n<ul>\n<li><strong>A1 style &#8211;<\/strong> This is the most common reference that we use when we are trying to provide cell reference. In this, you <strong>first provide the column number<\/strong> (indicated by A, B, C, etc) and<strong> then the row number<\/strong> (indicated by 1, 2, 3, etc). Example, the highlighted cell in the image below is B3<\/li>\n<\/ul>\n<p style=\"padding-left: 40px\"><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/06\/Screenshot-453.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Excel INDIRECT Function Using Sheet References\" class=\"alignnone size-full wp-image-18923\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/06\/Screenshot-453.png\" alt=\"Excel INDIRECT Function Using Sheet References\" width=\"319\" height=\"171\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/06\/Screenshot-453.png 319w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/06\/Screenshot-453-300x161.png 300w\" sizes=\"(max-width: 319px) 100vw, 319px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<ul>\n<li>R1C1 style &#8211; This reference is opposite to the A1 style i.e. <strong>first the row number and then column number<\/strong>. For example, <strong>R3C2<\/strong> refers to cell B3 which is row 3 and column 2 in a sheet.<a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/06\/Screenshot-453.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Excel INDIRECT Function Using Sheet References\" class=\"alignnone size-full wp-image-18923\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/06\/Screenshot-453.png\" alt=\"Excel INDIRECT Function Using Sheet References\" width=\"319\" height=\"171\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/06\/Screenshot-453.png 319w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/06\/Screenshot-453-300x161.png 300w\" sizes=\"(max-width: 319px) 100vw, 319px\" \/><\/a><\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<hr \/>\n<p>The INDIRECT function\u00a0is really cool as it can be used to <strong><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/excel-reference-sheet\/\" target=\"_blank\" rel=\"noopener\">reference sheet<\/a> cells or a range of cells<\/strong>.<\/p>\n<p>It <strong>opens up a lot of interesting possibilities<\/strong> as you can have fun creating flexible <a class=\"wpil_keyword_link\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/top-excel-formulas-function-examples-to-get-better-at-microsoft-excel\/\" target=\"_blank\" rel=\"noopener\" title=\"formulas\" data-wpil-keyword-link=\"linked\">formulas<\/a>, like indirectly summing the values that reside in another worksheet!<\/p>\n<p>Let&#8217;s look at a <strong>basic example<\/strong> to understand how this function works!<\/p>\n<p>&nbsp;<\/p>\n<h3><strong><a id=\"basic-use-of-indirect-function\"><\/a>Basic use of Indirect Function<\/strong><\/h3>\n<p>In the example below, you have used the Indirect function to return a value when the <strong>referenced range is a cell<\/strong>.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/06\/Screenshot-446.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Excel INDIRECT Function Using Sheet References\" class=\"alignnone size-full wp-image-18916\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/06\/Screenshot-446.png\" alt=\"Excel INDIRECT Function Using Sheet References\" width=\"1081\" height=\"510\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/06\/Screenshot-446.png 1081w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/06\/Screenshot-446-300x142.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/06\/Screenshot-446-1024x483.png 1024w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/06\/Screenshot-446-768x362.png 768w\" sizes=\"(max-width: 1081px) 100vw, 1081px\" \/><\/a><\/p>\n<p>You have the sales amount <strong>24,640<\/strong> stored in cell D2 and the text <strong>D2<\/strong> stored in cell I2.<\/p>\n<p>Now, when you type the formula =INDIRECT(I2) Excel will follow the steps below:<\/p>\n<ul>\n<li>It will first go to cell I2 which the formula refers to and get the value <strong>D2.<\/strong><\/li>\n<li>Next, it will go to cell D2 and pick the value <strong>24,640<\/strong> and display that result.<\/li>\n<\/ul>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/06\/Screenshot-447.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Excel INDIRECT Function Using Sheet References\" class=\"alignnone wp-image-18917 size-full\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/06\/Screenshot-447-e1596898466281.png\" alt=\"Excel INDIRECT Function Using Sheet References\" width=\"1096\" height=\"515\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/06\/Screenshot-447-e1596898466281.png 1096w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/06\/Screenshot-447-e1596898466281-300x141.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/06\/Screenshot-447-e1596898466281-1024x481.png 1024w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/06\/Screenshot-447-e1596898466281-768x361.png 768w\" sizes=\"(max-width: 1096px) 100vw, 1096px\" \/><\/a><\/p>\n<p>As you can see, the Excel Indirect Function<strong> converts the text string D2 into a cell reference<\/strong>.<\/p>\n<p>Using R1c1 style, the same formula will be: <strong>=INDIRECT(K2, FALSE)<\/strong><\/p>\n<p>Cell <strong>K2<\/strong> contains the cell reference in the <strong>R1C1 style<\/strong>.<\/p>\n<p>Make sure to provide the <strong>second argument of the function i.e. [a1]<\/strong>. <em>Here, it is FALSE.<\/em><\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/06\/Screenshot-454.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Excel INDIRECT Function Using Sheet References\" class=\"alignnone size-full wp-image-18924\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/06\/Screenshot-454.png\" alt=\"Excel INDIRECT Function Using Sheet References\" width=\"1284\" height=\"514\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/06\/Screenshot-454.png 1284w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/06\/Screenshot-454-300x120.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/06\/Screenshot-454-1024x410.png 1024w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/06\/Screenshot-454-768x307.png 768w\" sizes=\"(max-width: 1284px) 100vw, 1284px\" \/><\/a><\/p>\n<p>Until now, you have covered how to use Excel Indirect function when you are trying to fetch values from the same sheet.<\/p>\n<p>Let&#8217;s see how it works when you want to use an <strong>Excel reference cell in another sheet<\/strong> dynamically!<\/p>\n<h3 style=\"text-align: left\"><strong><a id=\"reference-a-cell-in-another-sheet\"><\/a>Reference a Cell in Another Sheet<\/strong><\/h3>\n<p>When the referenced range is a cell of a Sheet, the Excel <strong>INDIRECT function will go and\u00a0return the content of the referenced cell in that Sheet<\/strong>.<\/p>\n<p>Read below to learn how to insert Sheet reference in Excel Indirect Formula.<\/p>\n\n<p>Watch it on <a href=\"https:\/\/youtu.be\/pwvcv_BVgyw\" target=\"_blank\" rel=\"nofollow noopener\"><strong>YouTube<\/strong> <\/a>and give it a thumbs-up!<br \/>\n<iframe src=\"https:\/\/www.youtube.com\/embed\/pwvcv_BVgyw?rel=0 \" width=\"800\" height=\"400\" frameborder=\"0\" allowfullscreen=\"allowfullscreen\"><span data-mce-type=\"bookmark\" style=\"width: 0px;overflow: hidden;line-height: 0\" class=\"mce_SELRES_start\">\ufeff<\/span><\/iframe><\/p>\n<p><a href=\"https:\/\/www.youtube.com\/c\/MyExcelOnlinecomtutorials?sub_confirmation=1\" target=\"_blank\" rel=\"noopener noreferrer nofollow\"><img loading=\"lazy\" decoding=\"async\" class=\"alignmiddle wp-image-111468 size-full\" style=\"vertical-align: middle\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2019\/04\/1.yt_.png\" alt=\"\" title=\"\"><\/a><\/p>\n<p>Make sure to download the Excel Workbook below and follow along:<\/p>\n<p><strong><a class=\"IRPP_minimalist icon-download\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/08\/Indirect-Sheet-Reference.xlsx\" target=\"_blank\"><span class=\"ctaText px-3 text-capitalize\">Download excel workbook<\/span><span class=\"postTitle px-3\">Indirect-Sheet-Reference.xlsx<\/span><\/a><\/strong><\/p>\n<div class=\"jumbotron2\">\n<div class=\"meo-subcount-2\">\n<p><a id=\"om-f2q8uijmbbmwc3oohwuo-holder\" class=\"drop-shadow lifted btn btn-secondary\" href=\"https:\/\/app.monstercampaigns.com\/c\/f2q8uijmbbmwc3oohwuo\/\" target=\"_blank\" rel=\"nofollow noopener\">DOWNLOAD OUR<br \/>\nFREE EXCEL GUIDES<\/a><\/p>\n<p>&lt;!&#8212;-&gt;<\/p>\n<\/div>\n<\/div>\n<p>In this example, you have two Excel Indirect Sheet name &#8211; <strong>Summary Page<\/strong> &amp; January.<\/p>\n<p>In Sheet &#8211; January, you have <strong>sales data for the month of January<\/strong> and a <strong>total sales<\/strong> amount achieved in that month mentioned in cell <strong>I3<\/strong>.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/06\/Screenshot-448.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Excel INDIRECT Function Using Sheet References\" class=\"alignnone size-full wp-image-18919\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/06\/Screenshot-448.png\" alt=\"Excel INDIRECT Function Using Sheet References\" width=\"1031\" height=\"468\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/06\/Screenshot-448.png 1031w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/06\/Screenshot-448-300x136.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/06\/Screenshot-448-1024x465.png 1024w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/06\/Screenshot-448-768x349.png 768w\" sizes=\"(max-width: 1031px) 100vw, 1031px\" \/><\/a><\/p>\n<p style=\"text-align: left\">In the sheet &#8211; <strong>Summary Page<\/strong>, you want to pull the total sale figure in cell E11.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/06\/Screenshot-450.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Excel INDIRECT Function Using Sheet References\" class=\"alignnone size-full wp-image-18920\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/06\/Screenshot-450.png\" alt=\"Excel INDIRECT Function Using Sheet References\" width=\"520\" height=\"248\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/06\/Screenshot-450.png 520w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/06\/Screenshot-450-300x143.png 300w\" sizes=\"(max-width: 520px) 100vw, 520px\" \/><\/a><\/p>\n<p>You can use the formula below:<\/p>\n<p><strong>=INDIRECT(<span style=\"color: #0000ff\">&#8220;JANUARY!I3&#8221;<\/span>)<\/strong><\/p>\n<p>&nbsp;<\/p>\n<p>Sheet references are in the format of\u00a0<strong>SHEETNAME!CELL,\u00a0<\/strong>an example would be <strong>January!I3<\/strong> which would mean the cell <strong>I3<\/strong> in the worksheet named <strong>January<\/strong>.<\/p>\n<p>Say we enter in cell <strong>C11\u00a0<\/strong>the worksheet name: <em><strong>January<\/strong><\/em><\/p>\n<p>In another cell, we enter <strong>=INDIRECT(C11&amp;&#8221;!I3&#8243;),\u00a0<\/strong>which will translate into\u00a0<strong>=INDIRECT(&#8220;January!I3&#8221;)\u00a0<\/strong>as the ampersand\u00a0<strong>&amp;<\/strong>\u00a0will concatenate\/join the two strings together.<\/p>\n<p><strong>NB:<\/strong> <em>Highlighting the contents between the parenthesis and pressing the F9 key will confirm this:<\/em><\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/06\/f9.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Excel INDIRECT Function Using Sheet References\" class=\"alignnone wp-image-3434 size-full\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/06\/f9.png\" alt=\"Excel INDIRECT Function Using Sheet References\" width=\"310\" height=\"107\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/06\/f9.png 310w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/06\/f9-300x104.png 300w\" sizes=\"(max-width: 310px) 100vw, 310px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p>This will indirectly return the value that resides in cell <strong>I3<\/strong> in the worksheet named\u00a0<strong>January<\/strong>, which has the total sales amount of $2,718,086\u00a0in our example below:<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/06\/Indirect-Sheet-References-01.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Excel INDIRECT Function Using Sheet References\" class=\"alignnone size-full wp-image-3347\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/06\/Indirect-Sheet-References-01.png\" alt=\"Excel INDIRECT Function Using Sheet References\" width=\"746\" height=\"188\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/06\/Indirect-Sheet-References-01.png 746w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/06\/Indirect-Sheet-References-01-300x76.png 300w\" sizes=\"(max-width: 746px) 100vw, 746px\" \/><\/a><\/p>\n<p>This is how <a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/sum-a-row-in-excel\/\" target=\"_blank\" rel=\"noopener\">Excel sum<\/a> indirect another sheet reference works!<\/p>\n<p>The same formula for R1C1 style will be: <strong>=INDIRECT(C17&amp;&#8221;!R3C9&#8243;,FALSE)<\/strong><\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/06\/Screenshot-455.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Excel INDIRECT Function Using Sheet References\" class=\"alignnone size-full wp-image-18926\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/06\/Screenshot-455.png\" alt=\"Excel INDIRECT Function Using Sheet References\" width=\"506\" height=\"289\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/06\/Screenshot-455.png 506w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/06\/Screenshot-455-300x171.png 300w\" sizes=\"(max-width: 506px) 100vw, 506px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<h3 style=\"text-align: left\"><strong><a id=\"reference-a-range-of-cells-in-another-sheet\"><\/a>Reference a Range of Cells in Another Sheet<\/strong><\/h3>\n<p>When the referenced range is a range of cells of a Sheet, the Excel <strong>INDIRECT function will go and\u00a0return the content of the referenced cells of that Sheet<\/strong>.<\/p>\n<p>Instead of fetching the summation value from one cell, you can pull data from a <strong>range of cells i.e. D:D.<\/strong><\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/06\/Screenshot-451.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Excel INDIRECT Function Using Sheet References\" class=\"alignnone size-full wp-image-18922\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/06\/Screenshot-451.png\" alt=\"Excel INDIRECT Function Using Sheet References\" width=\"818\" height=\"507\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/06\/Screenshot-451.png 818w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/06\/Screenshot-451-300x186.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/06\/Screenshot-451-768x476.png 768w\" sizes=\"(max-width: 818px) 100vw, 818px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p>You can use the formula below:<\/p>\n<p style=\"text-align: left\"><strong>=SUM(INDIRECT(<span style=\"color: #0000ff\">&#8220;FEBRUARY!D:D&#8221;<\/span>))<\/strong><\/p>\n<p>&nbsp;<\/p>\n<p>We can then enter a SUM function which will total the referenced cells of that sheet.<\/p>\n<p>Say we enter in cell <strong>G12 <\/strong>the worksheet name:<strong>\u00a0<em><strong>February<\/strong><\/em><\/strong><\/p>\n<p>In another cell we enter <strong>=SUM(INDIRECT(G12&amp;&#8221;!D:D&#8221;))<\/strong><strong>,\u00a0<\/strong>which will translate into\u00a0<strong>=SUM(INDIRECT(&#8220;February!D:D&#8221;))\u00a0<\/strong>as the ampersand\u00a0<strong>&amp;\u00a0<\/strong>will concatenate\/join the two strings together.<\/p>\n<p>This will indirectly Sum the values that reside in column <strong>D<\/strong> in the worksheet named\u00a0<strong>February<\/strong>, which is <strong>$2,584,131<\/strong>\u00a0in the example below (<em>click to expand image<\/em>):<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/06\/Indirect-Sheet-References-02.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Excel INDIRECT Function Using Sheet References\" class=\"alignnone size-full wp-image-3349\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/06\/Indirect-Sheet-References-02.png\" alt=\"Excel INDIRECT Function Using Sheet References\" width=\"1285\" height=\"540\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/06\/Indirect-Sheet-References-02.png 1285w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/06\/Indirect-Sheet-References-02-300x126.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/06\/Indirect-Sheet-References-02-1024x430.png 1024w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/06\/Indirect-Sheet-References-02-768x323.png 768w\" sizes=\"(max-width: 1285px) 100vw, 1285px\" \/><\/a><\/p>\n<p>This is how Excel will use indirect function excel different sheet reference and fetch values from there!<\/p>\n<p>The same formula for R1C1 style will be:<strong> =SUM(INDIRECT(G17&amp;&#8221;!C4:C4&#8243;,FALSE))<\/strong><\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/06\/Screenshot-457.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Excel INDIRECT Function Using Sheet References\" class=\"alignnone size-full wp-image-18927\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/06\/Screenshot-457.png\" alt=\"Excel INDIRECT Function Using Sheet References\" width=\"607\" height=\"264\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/06\/Screenshot-457.png 607w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/06\/Screenshot-457-300x130.png 300w\" sizes=\"(max-width: 607px) 100vw, 607px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<h3><strong><a id=\"conclusion\"><\/a>Conclusion<\/strong><\/h3>\n<p>In this article, you have learned about <strong>Indirect Function in Excel<\/strong> &#8211; Syntax, Basic Example, using cell reference A1 style &amp; R1C1 style, when reference cell is in another sheet &amp; when reference is a range of cells in another sheet.<\/p>\n<p>There is a lot that this incredible function &#8211; INDIRECT can do. <strong><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/category\/formulas\/lookup\/indirect\/\" target=\"_blank\">Click here to know all about it<\/a><\/strong>!<\/p>\n<p><strong>Further Learning:<\/strong><\/p>\n<ul>\n<li><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/indirect-function-for-dependent-dropdown-lists-in-excel\/\" target=\"_blank\" rel=\"noopener\">INDIRECT Function for Dependent Dropdown Lists in Excel<\/a><\/li>\n<li><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/indirect-function-excel\/\" target=\"_blank\" rel=\"noopener\">INDIRECT Function in Excel<\/a><\/li>\n<li><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/how-to-master-excel-formulas\/\" target=\"_blank\" rel=\"noopener\">How to Master Excel Formulas &#8211; The Ultimate Guide<\/a><\/li>\n<\/ul>\n<p>You can learn more about how to use Excel by viewing our FREE Excel webinar training on <strong><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/100-43.html\" target=\"_blank\" rel=\"noopener noreferrer\">Formulas<\/a>, <a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/100-5.html\" target=\"_blank\" rel=\"noopener noreferrer\">Pivot Tables<\/a>,<\/strong> and <strong><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/100-39.html\" target=\"_blank\" rel=\"noopener noreferrer\">Macros &amp; VBA<\/a><\/strong>!<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/100-43.html\" target=\"_blank\" rel=\"noopener noreferrer\"><img loading=\"lazy\" decoding=\"async\" title=\"HLOOKUP Function in Excel: Introduction\" class=\"alignnone wp-image-9146 \" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/07\/Blog_image_title_FORMULAS-1024x683.jpg\" alt=\"HLOOKUP Function in Excel: Introduction\" width=\"533\" height=\"355\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/07\/Blog_image_title_FORMULAS-1024x683.jpg 1024w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/07\/Blog_image_title_FORMULAS-300x200.jpg 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/07\/Blog_image_title_FORMULAS-768x512.jpg 768w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/07\/Blog_image_title_FORMULAS.jpg 1200w\" sizes=\"(max-width: 533px) 100vw, 533px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Excel Indirect function can be used to return a valid reference from a given text string. The cell reference provided in this formula will not change when you add or delete rows and\/or columns. For Example, =INDIRECT(A1: E1) will always refer to the first 5 columns of the sheet even if new columns are added [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":17119,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"cos_headline_score":0,"cos_seo_score":0,"cos_headline_text":"Excel INDIRECT Function Using Sheet References","cos_headline_has_been_analyzed":false,"cos_last_analyzed_headline":[],"om_disable_all_campaigns":false},"categories":[11,3,279],"tags":[43,134,79],"acf":[],"_links":{"self":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts\/3344"}],"collection":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/comments?post=3344"}],"version-history":[{"count":0,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts\/3344\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/media\/17119"}],"wp:attachment":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/media?parent=3344"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/categories?post=3344"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/tags?post=3344"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}