I have a formula like this in one cell:

Formula:
--------------------
=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.


--
aposatsk
------------------------------------------------------------------------
aposatsk's Profile: http://www.excelforum.com/member.php...o&userid=36709
View this thread: http://www.excelforum.com/showthread...hreadid=572614

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.

--
Regards,
Fred


"aposatsk" wrote in
message ...

I have a formula like this in one cell:

Formula:
--------------------

=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.


--
aposatsk
------------------------------------------------------------------------
aposatsk's Profile:
http://www.excelforum.com/member.php...o&userid=36709
View this thread: http://www.excelforum.com/showthread...hreadid=572614

$ 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.

"Fred Smith" wrote:

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.

--
Regards,
Fred


"aposatsk" wrote in
message ...

I have a formula like this in one cell:

Formula:
--------------------

=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.


--
aposatsk
------------------------------------------------------------------------
aposatsk's Profile:
http://www.excelforum.com/member.php...o&userid=36709
View this thread: http://www.excelforum.com/showthread...hreadid=572614