|
Formula not changing when Dragged!!!!
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 |
Formula not changing when Dragged!!!!
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 |
Formula not changing when Dragged!!!!
$ 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 |
| All times are GMT +1. The time now is 11:59 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com