so I managed a semi efficient work around.

i copied the item numbers from the inbound inventory, I then created a
column with a vlookup searching in the current inventory for the new
inventory item num, I then sorted based on the vlookup column so i got
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 to
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...


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