I would suggest that your data has leading or trailing spaces in these
entries, either in the NewParts list or in the Whse345 list. Something such
as this would make them not match.

--
Regards,
Tom Ogilvy


"DA@PD" wrote in message
...
Hello again experts...
I just realized that the VLookup command that I've been using to scrub a
parts list of a new warehouse we acquired against our existing warehouses
is
not working. I've been using the following formula

=VLOOKUP(NewParts!A2,'Whse345'!B$2:B$8106,1,FALSE)

A bulk of the parts that I'm scrubbing come in the format of #A####. And
for some reason, when I try to match one of these part numbers against the
list I already have, it gives me N/A#. The above formula is working fine
for
all of the 7 number only part numbers, its just the part numbers that come
in
the format of 1X3456.

Any Ideas????