VLOOKUP

C

citygirl

How can I stop the table-array from changing when I drag-copy VLOOKUP down a
sheet.
 
G

Gord Dibben

Either use $ signs like $A$1:$D$52

Or give the range a defined name like TheTable through Insert>Name>Define

Then the formula would be =VLOOKUP(G1,TheTable,2,FALSE)


Gord Dibben MS Excel MVP
 

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

Dragging a formula down isn't working - where am I going wrong? 1
VLookup Won't Copy down (#REF! error) 1
Help With VLOOKUP 2
Vlookup 1
vlookup formatting problem 1
VLOOKUP duplicate values in table the table array? Help me solve 1
Vlookup error 1
Can I add a formula or function to Vlookup? 1

Top