Vlookup - need the array to be constant
 

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

Vlookup - need the array to be constant
 

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


--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"reesrob" wrote in message
...
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

Vlookup - need the array to be constant
 

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

"reesrob" wrote in message
...
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