Have a look in HELP index for MATCH to find the row for the old part and
index or offset.

--
Don Guillett
SalesAid Software

"Darren Woodbrey" wrote in message
...
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