Formula not changing when Dragged!!!!

[aposatsk]

I have a formula like this in one cell:

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

--
Regards,
Fred


"aposatsk" <[email protected]> wrote in
message news:[email protected]...
>
> 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.
>
>
> --
> aposatsk
> ------------------------------------------------------------------------
> aposatsk's Profile:
> http://www.excelforum.com/member.php...o&userid=36709
> View this thread: http://www.excelforum.com/showthread...hreadid=572614
>

[Dave F]

$ 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" <[email protected]> wrote in
> message news:[email protected]...
> >
> > 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.
> >
> >
> > --
> > aposatsk
> > ------------------------------------------------------------------------
> > aposatsk's Profile:
> > http://www.excelforum.com/member.php...o&userid=36709
> > View this thread: http://www.excelforum.com/showthread...hreadid=572614
> >
>
>
>