Indirect Function in Microsoft Excel

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.

img1

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.

img2

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.

img3

Follow below mentioned steps:-

  • Select the cell C1 and write the formula.
  • =SUM(INDIRECT(“B11:B20″)), press enter.
  • The function will return sum of B11:B20.

img4
img5

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.

 

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>

Terms and Conditions of use

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.

Visit Us On TwitterVisit Us On FacebookVisit Us On Google PlusVisit Us On Youtube