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