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

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
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <at>yahoo<dot>com
----
SRF <[email protected]> wrote in message
news:[email protected]...
> =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