I've got the lookup set to use exact matches. That's why I get the N/A as a
result. But a part number I know is in the sheet is not being found. Even
when I copy and paste it from the list.

"Jason Morin" wrote:

I'm speculating that you're not specifying the VLOOKUP
formula to find an exact match. To do this, include a 0
in the fourth argument:

=VLOOKUP(---,---,---,0)

This forces an exact match and does not require your
lookup table to be sorted.

If this doesn't do the trick, email me the file and I'll
take a look. Replace OPPOSITEOFCOLD with the word "hot".

HTH
Jason
Atlanta, GA

-----Original 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!
.