Vlookup - need the array to be constant

R

reesrob

I am doing some data analysis and using the vlookup function to search and
match product codes in different tabs. I have lots of these to do. THe
formula I am using is;

VLOOKUP(E4,'LRP'!A1:B257, 2, FALSE)

WHen I use Ctrl D to fill down, the lookup value increases as it should.
However, I want the table array to remain constant.

Thus the second line of my sheet reads as follows;

=VLOOKUP(E5,'LRP'!A2:B258, 2, FALSE)

Where the E5 is correct. However, the table array needs to remain as A1:B257.

THere has to be a way of doing this without having to type into each cell
doesn't there?

Help appreciated

Vern
 
B

Bob Phillips

=VLOOKUP(E4,'LRP'!$A$1:$B$257, 2, FALSE)

or better still, assign a defined name to 'LRP'!A1:B257 and use that

=VLOOKUP(E4,table_data, 2, FALSE

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)
 

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

Top