compare lists, extract new values

[trav]

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]

so I managed a semi efficient work around.

i copied the item numbers from the inbound inventory, I then created
column with a vlookup searching in the current inventory for the ne
inventory item num, I then sorted based on the vlookup column so i go
all my errors together. I then deleted out the rows that found matchs
and was left with the new item numbers, for which i created a vlookup t
bring in all of the rest of the info for the product (price, qty, ect).

Is this the best method?

I am thinking there has to be an easier way..