results of the VLOOKUP are intermittent
which means??
I just made a list of 65000 and it worked just fine to find the correct
result. Perhaps your part numbers are a mixture of numbers and text and not
sorted as you expect.
--
Don Guillett
SalesAid Software

"Chris Kellock" <Chris wrote in message
...
I have made several worksheets for lookup up pricing for our various
product
lines. These sheets look up a description, list price, and my cost in
another worksheet (in the same XLS file) based on the part number I enter
on
the first sheet. The list on the second page has been assigned a name,
and
I'm using VLOOKUP to find the part number in that range, and then return
the
values into my original sheet. The list is sorted alphabetically by the
part
number. I can send the file is someone can help!

My problem is that if the lookup list has over about 5,000 items, the
results of the VLOOKUP are intermittent. I can actually copy and paste a
value from the list into my sheet and it won't look up. Some of my price
lists are over 15,000 items.

Does anyone have any experience with VLOOKUP not working in a large list?
How about any ideas of how to make it work more reliably. I have one
sheet
I'm trying to make that I expect to have about 50,000 items in it. I
desperately need to get this worksheet working. Please help!