Thread: How do I copy a formula in excel where part remains absolute the .
View Single Post
  #1   Report Post  
SRF
 
Posts: n/a
Default How do I copy a formula in excel where part remains absolute the .
=VLOOKUP(A2,Sheet2!A1:B664, 2, FALSE). I want the A2 to change when I go to
the next cell but I need the Lookup range in sheet 2 (A1:B664) to reamin the
same.

Thanks
Reply With QuoteReply With Quote