Indirect range not changing

  • Thread starter Thread starter Pat
  • Start date Start date
P

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

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

Frank
 
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
 
When using Indirect in the following formula IV11 will not change to IV12
when filled down.


=$AS11+$BF11+$CU11-$DT11-INDIRECT("IV11")
Click to expand...

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

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