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 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
 
Back
Top