Cell Reference

[Ankur Bhateja]

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
(e-mail address removed)

 

[David Biddulph]

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))