LOOKUP function copy as ABSOLUTE

D

Dan

I have the following formula:
=LOOKUP(Schedule!D2,Projects!$A2:$A52,Projects!$B2:$B52)
When I try to copy to subsequent rows I get:
=LOOKUP(Schedule!D3,Projects!$A3:$A53,Projects!$B3:$B53)
=LOOKUP(Schedule!D4,Projects!$A4:$A54,Projects!$B4:$B54)
etc.....
I want to keep the absolute reference of Projects!$A2:$A52,Projects!$B2:$B52
Why won't the copy paste function handle this?

Thanks in advance - Dan
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

LOOKUP function copy as ABSOLUTE? 5
Lookup question 3
Lookup / Summary Table 8
How to look up 2 Cell Values 9
Can a cell be turned on or off? 1
Lookup Function Referencing cells, not text values 3
check data from different cells 1
EXCEL LOOKUP 4

Top