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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

=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
 
You must log in or register to reply here.

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

Copy part of VLOOKUP formula? 4
Multiple columns using Vlookup 3
Copying functions without changing most variables in it 3
Copy a formula using Vlookup 2
locking part of look up formula 2
EXCEL - IF(IFERROR(VLOOKUP question 0
How Do I Make Vlookup Continue Looking 0
how do i use the text in a cell as a named range in a vlookup form 2

Back
Top