One formula calculating from another

L

Luke

What I want to do is to write a formula which will look into the formula of
the cell to its left and add an extra column. e.g. one formula returns the
value of cell B20 in another report, I want the formula to look at this cell
and then add a column i.e. return the value of C20 in the report. The next
cell will look at D20 and so on.

Is this at all possible?

Luke

p.s. The initial formula (=B20) will change every week and I don't want to
copy and paste the formula due to the size of the report and the large amount
of time this will take up.
 
F

Frank Kabel

Hi
one way:
- put the cell reference in a separate cell (e.g. in cell
X1). e.g. cell X1 contains the value
B20
(without the equation sign).

Now use the following type of formulas:
=INDIRECT(X1)
=OFFSET(INDIRECT(X1),0,1)
 
L

Luke

Frank,

Thanks for replying, but unfortunately the formula I am trying to 'offset'
is in a different workbook. I tried putting the whole formula in a cell e.g.
"R:\Stats[WorkbookName]Sheet1'!$AU$20" and then applying the offset to this,
but to no avail.

Is this possible any other way or am I just asking too much?

Luke
 
F

Frank Kabel

Hi
INDIRECT only accepts open workbooks. See the following
thread for alternatives:
http://tinyurl.com/2c62u
-----Original Message-----
Frank,

Thanks for replying, but unfortunately the formula I am trying to 'offset'
is in a different workbook. I tried putting the whole formula in a cell e.g.
"R:\Stats[WorkbookName]Sheet1'!$AU$20" and then applying the offset to this,
but to no avail.

Is this possible any other way or am I just asking too much?

Luke

Frank Kabel said:
Hi
one way:
- put the cell reference in a separate cell (e.g. in cell
X1). e.g. cell X1 contains the value
B20
(without the equation sign).

Now use the following type of formulas:
=INDIRECT(X1)
=OFFSET(INDIRECT(X1),0,1)
look
into the formula of formula
to look at this cell the
report. The next report
and the large amount
Click to expand...
.
Click to expand...
 
Top