Thread: Formula not changing when Dragged!!!!
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
aposatsk aposatsk is offline
external usenet poster
  
Posts: 1
Default 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

Reply With QuoteReply With Quote