Cell Reference
 

What I am looking for is that when I enter a formula (In cell B1) to pick up
value in A1. Now I need value from cell A5 in cell B2. Next value I need in
B3 is A9. Everytime I have to change the cell values manually in column B.

Formula I use : - =IF(OR(AK64<$D$4,AK64=$D$4),H331,0)
Now I need value from cell H336 and I manually change H331 to H336 shown below

=IF(OR(AK64<$D$4,AK64=$D$4),H336,0)

Any way to make this automated.

Thanks
Ankur Bhateja

Cell Reference
 

Instead of =IF(OR(AK64<$D$4,AK64=$D$4),H331,0)
you could say
=IF(AK64<=$D$4,H331,0)

If what you want is to be able to step the H331 5 rows down when you copy
the formula down a row, without the other references changing, try
=IF(AK$64<=$D$4,OFFSET(H$331,5*(ROWS(A$1:A1)-1),0))
--
David Biddulph


"Ankur Bhateja" <Ankur wrote in message
...
What I am looking for is that when I enter a formula (In cell B1) to pick
up
value in A1. Now I need value from cell A5 in cell B2. Next value I need
in
B3 is A9. Everytime I have to change the cell values manually in column
B.

Formula I use : - =IF(OR(AK64<$D$4,AK64=$D$4),H331,0)
Now I need value from cell H336 and I manually change H331 to H336 shown
below

=IF(OR(AK64<$D$4,AK64=$D$4),H336,0)

Any way to make this automated.

Thanks
Ankur Bhateja