Formula not changing when Dragged!!!!

[aposatsk]

I have a formula like this in one cell:

PHP code:
--------------------
=IF(H$28<16,IF(H$28=0,0,LOOKUP(H$28,B$11:U$11,B$12:U$12)),LOOKUP(H$28,B$19:M$19,B$20:M$20))
--------------------


But when I try to drag it down the column, values that should change in
the formula do not! Every instance of H$28 should change to H$29, then
H$30, etc., but they do not! The formula remains identical, hence
giving me the same result.

 

[Fred Smith]

Excel is working as it should. The $ in your formula are what prevent it from
changing. Take them out, and it will solve your problem.

Then look in Help for the difference between an absolute reference and a
relative one.

 

[Guest]

$ signs indicate absolute references; i.e., as you drag H$28 down the only
thing that will change is the column reference (H) not the row reference (28).

Look in Excel's help for absolute and relative references for more
information.