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