Indirect range not changing

[Pat]

When using Indirect in the following formula IV11 will not change to IV12
when filled down.


=$AS11+$BF11+$CU11-$DT11-INDIRECT("IV11")

Anyone know how this can be done.

Pat

 

[Frank Kabel]

Hi Pat
one way (if your formula starts also in row 11):
=$AS11+$BF11+$CU11-$DT11-INDIRECT("IV" & ROW())

Frank

 

[Frank Kabel]

Hi
try the following
=$AS11+$BF11+$CU11-$DT11-INDIRECT("IV" & ROW())
ROW() return the row number of the current row

Frank

 

[Pat]

Hello Frank

This has worked fine, only I notice if I delete a column the formula changes
from:

=$AS11+$BF11+$CU11-$DT11-INDIRECT("IV" & ROW(IV11))

to:

=$AS11+$BF11+$CU11-$DT11-INDIRECT("IV" & ROW(IU11))

After using the code you provided me with earlier the value is still
correct.

Should I worry about this?

regards
Pat

 

[Aladin Akyurek]

Just curious: What do you have in IV11 that requires you to use INDIRECT?

 

[Pat]

A formula resides in IV which must always remain in that column.

Pat

 

[Harlan Grove]

When using Indirect in the following formula IV11 will not change to IV12
when filled down.


=$AS11+$BF11+$CU11-$DT11-INDIRECT("IV11")

If you're entering this in some other cell in row 11, you could try

=$AS11+$BF11+$CU11-$DT11-INDIRECT("RC256",0)