Thread
:
Vlookup - need the array to be constant
View Single Post
#
2
Posted to microsoft.public.excel.worksheet.functions
Don Guillett
external usenet poster
Posts: 10,124
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
Reply With Quote
Don Guillett
View Public Profile
Find all posts by Don Guillett