Indirect Function in Excel

Hello all. Let’s look at Indirect function. Indirect function would return a reference (or reference range) from a specified string. Syntax: =Indirect(ref_text, [a1]) Let’s look at some examples. In the below example, we have one value in each worksheet (sheet1,2&3). Let’s return each of them using the indirect function Next, let’s create a named rangeContinue reading “Indirect Function in Excel”