### INDIRECT() Function

The INDIRECT() function returns the value of the cell referenced by a text string. The syntax for this function is:

INDIRECT(ref_text, A1)

ref_text is a reference to a cell in an A1-style reference, an R1C1-style reference, a name defined as a reference, or a reference to a cell as a text string. If it's not a valid cell reference, it will return #REF!.

A1 is a logical value that indicates what type of reference is on cell ref_text. If A1 is true or omitted, ref_text will be interpreted as an A1-style reference; if A1 is FALSE, ref_text will be interpreted as an R1C1-style reference.

Let's see a simple example of the use of this function. Let's say that we have this workbook that has a sheet for each month of sales.

On cell B3 we want to sum the sales values of the range A1:A10 for the month that we specify on cell B1, in this case "Feb" that corresponds to the Feb sheet on our workbook. For this we can put a formula using INDIRECT() function on cell B3 like this:

=SUM(INDIRECT(B1&"!A1:A10"))

#### 6 comentários:

locojoe61 said...

I love 'indirect', your can create the RC for everchanging data tables, BUT.... why can't you use it for defining a range in a chart/graph? what can be use???/

jppinto said...

You can use INDIRECT function as a range for a chart!

eldertrag said...

How do you use 'indirect' as a chart range? I have tried without success.

eldertrag

Unknown said...

How do i use this function when i need to change workbook?
For exemple:
+[02.10.2012.xlsx]RU!\$D\$17

Part to need a change is this [02.10.2012.xlsx]
it's a address for another workbook...

Quân Đào said...