I think this is a VLOOKUP, but cannot figure it out.

I have
column A = old part#
column B = old price
column C = new part#
column D = new price

There may be additional part numbers in the new list vice versa and they are
not sorted the same way.

I need to find each old part# in the new part# list and then return the part
number if the price is different. It would be good to return the new price
as well. Any help would be greatly appreciated. Thanks!


Darren