LOOKUP function copy as ABSOLUTE?

  • Thread starter Thread starter Dan
  • Start date Start date
D

Dan

I have the following formula:
LOOKUP(Schedule!D2,Projects!$A2:$A52,Projects!$B2:$B52)
When I copy this to subsequent columns it looks like this:
LOOKUP(Schedule!D3,Projects!$A3:$A53,Projects!$B3:$B53)
LOOKUP(Schedule!D4,Projects!$A4:$A54,Projects!$B4:$B54)
etc...
I want the Projects piece to stay as absolute reference.
Why does the copy not recognize this?

Thanks in advance - Dan
 
Andy,

Sorry about that. I did not see the post and was watching
for it yesterday and looked today and did not see it. Is
there an easy way to monitor 1 post without a newsreader
program?

Dan
 
Dan

Not easily. I just use Outlook Exchange, which works well enough for me.
Even though it's basic, it's far, far better than using the net.

Andy.
 
I have the same situation and don't know how to correct
it either...I've looked for the reply email with the
solution but can't seem to find it. Would you be kind
enough to show me how you corrected your formula to make
it work? Thanks a million (I've searched the Excel Help
and other MS-Office help sites and still to no avail).
Marty
 
LOOKUP(Schedule!D2,Projects!$A$2:$A$52,Projects!$B$2:$B$52)

the issue here is that the row references changed when copied down. To keep
the row references for the lookup range(s) the same while copying down, you
need to set both parts of the cell reference to absolute, hence the $a$2
format.

Steve
 
Back
Top