I have two spread sheet, one with a list of current products, and
another with a list of new inventory that came in.

I would like to be able to generate a list of new items that came in
that are not on the current product list.

Is there an easy way of doing this without creating a macro.
Currently I am just using a vlookup() formula and whereever there is an
error I manually cut and paste into a new list. It is not very
efficient.

Any thoughts.

Trav


--
trav
------------------------------------------------------------------------
trav's Profile: http://www.excelforum.com/member.php...o&userid=31420
View this thread: http://www.excelforum.com/showthread...hreadid=542292