How do I copy a formula in excel where part remains absolute the .

S

SRF

=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
 
M

Max

Putting dollar signs around the lookup range:
Sheet2!$A$1:$B$664
will make it absolute (locked)

So, assuming the lookup values are listed in A2 down
you could put in say, B2:
=VLOOKUP(A2,Sheet2!$A$1:$B$664, 2, FALSE).
and just copy B2 down
 
Top