Updating cells from values in a second workbook

[Erwin]

Need help in two areas.

I have a price list workbook in 97. Three columns: part number, description
and price. I would like to update that workbook by bringing in price values
from a second workbook (also 97), with the part number as the common key.

I also have new parts in the second workbook that are not contained in the
first that I would like to bring those items [part number, description and
price] into the first workbook without duplicating part numbers that already
exist in the first.

Solutions are very much appreciated.

 

[Jerry W. Lewis]

You could use MATCH() in the second workbook to identify part numbers
that are not in the price list workbook.

You could use VLOOKUP() in the price list workbook to bring in extra
information from the second workbook by part number.

Jerry

 

[Erwin]

Just thought I'd let you know that the functions worked well, although the
VLOOKUP results needed minor manual correcting.

Thanks for the response.

--
Erwin

You could use MATCH() in the second workbook to identify part numbers
that are not in the price list workbook.

You could use VLOOKUP() in the price list workbook to bring in extra
information from the second workbook by part number.

Jerry

Need help in two areas.

I have a price list workbook in 97. Three columns: part number, description
and price. I would like to update that workbook by bringing in price values
from a second workbook (also 97), with the part number as the common key.

I also have new parts in the second workbook that are not contained in the
first that I would like to bring those items [part number, description and
price] into the first workbook without duplicating part numbers that already
exist in the first.

Solutions are very much appreciated.

 

[Jerry W. Lewis]

Glad it helped. And thank you for the feedback.

Jerry

Just thought I'd let you know that the functions worked well, although the
VLOOKUP results needed minor manual correcting.

Thanks for the response.

--
Erwin

You could use MATCH() in the second workbook to identify part numbers
that are not in the price list workbook.

You could use VLOOKUP() in the price list workbook to bring in extra
information from the second workbook by part number.

Jerry

Erwin wrote:

Need help in two areas.

I have a price list workbook in 97. Three columns: part number,

description

and price. I would like to update that workbook by bringing in price

values

from a second workbook (also 97), with the part number as the common

key.

I also have new parts in the second workbook that are not contained in

the

first that I would like to bring those items [part number, description

and

price] into the first workbook without duplicating part numbers that

already

exist in the first.

Solutions are very much appreciated.