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

 

[Guest]

Re-order your columns as follows:

Column A Column B Column C Column D
New Part# Old Part# old Price New Price

Lets define this lookup table as the following range: W1:Z24.

Sort on New Part# - This has to be sorted to work. If you add a new item, it
has to be resorted.

In the column where you want the old part number the vlookup will look like
the following:

=vlookup(column A,W1:Z24, 2)

For the old pice you would have :
=vlookup(column A, W1:Z24, 3)

etc.

Hope that helps!

 

[Don Guillett]

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