Hi, I asked this question earlier today, but didn't see it posted on the
boards, so I'm asking again... sorry if this turns out to be a repost...

My company has just acquired a warehouse full of parts, and has asked me to
scrub the part #'s from the new inventory against our other 7 warehouses to
determine any new parts # that need to be loaded into the system..

I am trying to use If(NA(Vlookup,etc..etc..)) formulas to determine when
there is a match from the new list against say Warehouse1, when there is not,
I want to run the "non-matching" parts against the next warehouse, and so on
and so forth to wittle the part #'s that need to be loaded into the system as
small as possible.

I have been trying to accomplish this using if(isNA(Vlookup) and creating a
list of "non-matching numbers" with a simple if,then command, the problem is
that when I try to move to the next step of the elimination process, the
program seems to not ignore the already matched part numbers that were 0's
from the previous step....

This should be a simple task, but I've spent 3 days trying to widdle down
this list of 4,500 part numbers, which I probably could have almost done by
hand by now... Can you give me a simple logic to follow that I'm missing or
a VBA script that would help with a stepped elimination of these part #'s?
Thank you!!!