I have upc numbers located in column A1:A7775 that are all unique to a
specific price on the same worksheet. Worksheet is named,
CLIENT_DISQUETTE_PRIX__IFC. The prices for these unique upc numbers are
located in column M1:M7775 of the same worksheet with each price
corresponding to one upc number. I am trying to bring prices from a
worksheet within the same file named IFC PRICE 2008. This worksheet also has
unique upc number in column A and Prices in column M. I was hoping that
excel can use the upc number from the worksheet, CLIENT_DISQUETTE_PRIX__IFC
and match them to the upc numbers from the worksheet, IFC PRICE 2008 and only
bring the price over, and place the price into column M matching it to the
unique upc number. PLEASE HELP!!
--
Mike Fitz


"JLatham" wrote:

Look at the worksheet function VLOOKUP(). I believe you may be able to use
that to match old and new by UPC number and bring over the new pricing.

Tell us a little more about how the sheets are laid out (what columns the
UPC codes are in, and what columns the price(s) are in) and we may be able to
be more specific. Sheet names involved would be good to know also, since
you're apparently talking about 2 workbooks.

"fitzsociety" wrote:

I am working on matching upc numbers from our vendor with our companies part
numbers. I have started working on this for a few months but half way the
new prices for 2008 have been downloaded and I have no idea how to take the
prices from another worksheet and match them to the worksheet I have now.
Each price can be referenced with a unique upc number.
--
Mike Fitz