VLOOKUP?

[Darren Woodbrey]

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

 

[L. Howard Kittle]

Hi Darren,

With the data in columns A through D, select three cell in a single row and
enter this formula in the highlighted cell and hit CTRL + SHIFT + ENTER.
Excel will enclose the formulas with { }.

=VLOOKUP(E1,A16,{2,3,4},0)

Now enter the OLD part number in cell E1. Should return the old price from
column B, the new part number from column C and the new price from column D.

HTH
Regards,
Howard