View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
fitzsociety fitzsociety is offline
external usenet poster
 
Posts: 7
Default matching upc numbers and prices

This worked like a champ. There is one more issue. Some of the upc numbers
are being used for different parts, so the prices came over but do not match
with the changed upc number. Do you think it is possible to also have it
look for other identifiers such as the diameter and length. The diameter is
located in column g and the length is located in column h. that way if these
dont match it will show n/a. Then i will go through the n/a. I appreciate
any help.
--
Mike Fitz


"JLatham" wrote:

Try this formula in cell M1 on the CLIENT_DISQUETTE_PRIX__IFC sheet:

=VLOOKUP(A1,'IFC PRICE 2008'!A$1:M$7775,13,FALSE)

Fill that formula down column M to row 7775 and your costs from the other
sheet should appear there - if the UPC code on this sheet is not on the IFC
PRICE 2008 sheet, you wll get a #N/A error in a cell in column M.

If there are values in column N down to row 7775 of the CLIENT... sheet, you
can quickly fill the formula down the sheet by moving the cursor to the lower
right corner of M1 until it turns into a thin plus sign (+) instead of its
normal fat cross and then double-click the left mouse button.

Another way, select M1 and then in the Excel 'Name Box' (where you see the
indication that you've chosen cell M1 just above column A on the sheet) and
type in M1:M7775 and then choose Edit | Fill | Down.

Hope this helps you out.

"fitzsociety" wrote:

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