In this article we will learn about how and where we can use the Indirect Function in Microsoft Excel.
Indirect function returns the reference specified by a text string. This function is used to create a reference that won’t change if row or columns are inserted on the worksheet.
Syntax of INDIRECT:- =INDIRECT(ref_text,[a1])
Ref Text: - A cell reference or text string (or both) that generate the range reference. The referenced range can be a cell a range of cells or a named range.
A1: - If the argument is TRUE, or omitted, the ref_text is A1 style. If the argument is FALSE, the ref text is R1C1 style.
For Example: - Cell A1 contains the Cell reference C5 and cell C5 contains 4. Write the function in cell B1 =INDIRECT(A1,TRUE)
The function will return 4, cell C5 reference.
You can write the formula in another way.
For Example: - Cell A1 contains the Cell reference C5 and cell C5 contains 4. Write the function in cell B1 =INDIRECT("A1")
The function will return 4.
Now we will learn about that how INDIRECT function can be used along with another function.
Let’s take an example, we have score data in range A2:B20. In which column A contains the candidate name and column B contains Score.
We will put here Sum function along with Indirect function.
Follow below mentioned steps:-
This is the way you can use the Indirect function along with another function which will help us indirectly to pick the value in Microsoft Excel 2010 and 2013.
The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.