+ Reply to Thread
Results 1 to 4 of 4

Looking up new bar codes and matching to product.

  1. #1
    Registered User
    Join Date
    07-29-2013
    Location
    San Diego
    MS-Off Ver
    excel 2010
    Posts
    2

    Looking up new bar codes and matching to product.

    See attached sheets:

    New product codes (sheet 2- Horizontal rows B1 through E10 need to be applied to products on sheet 1 according to size (vertical column F)...the common name (product color) is in column 1 on code sheet 2...matching the same name repeated for each of the four sizes in column 4 on product sheet.

    The problem is coming up with a formula that places all the correct codes on the product sheet in column K...and being able to copy it down for several hundred different products.

    I've tried multiple ways with both VLOOKUP and INDEX/MATCH combos without success.

    Any help much appreciated.
    Thanks

    code matching to products.xlsx
    Last edited by rsuits; 09-03-2014 at 09:34 PM. Reason: Attach file:

  2. #2
    Valued Forum Contributor
    Join Date
    04-22-2014
    Location
    Auckland, New Zealand
    MS-Off Ver
    Office 365 (work) and Excel 2013 (home)
    Posts
    1,167

    Re: Looking up new bar codes and matching to product.

    To attach a file, push the button with the paperclip (or scroll down to the Manage Attachments button), browse to the required file, and then push the Upload button.
    Please add reputation by clicking on the * if I have helped.
    Please mark the thread SOLVED if your issue has been resolved.
    Thanks, Glenn.

  3. #3
    Forum Expert boopathiraja's Avatar
    Join Date
    07-12-2013
    Location
    Coimbatore,TamilNadu, India
    MS-Off Ver
    Excel 2007, 2013, 2016, 365
    Posts
    1,455

    Re: Looking up new bar codes and matching to product.

    Hi, Welcome to the forum,

    Try with the below formula in the attached file (slight modification done in column B)

    Formula: copy to clipboard
    Please Login or Register  to view this content.


    Does that help ?
    Attached Files Attached Files
    Click just below left if it helps, Boo?ath?

  4. #4
    Registered User
    Join Date
    07-29-2013
    Location
    San Diego
    MS-Off Ver
    excel 2010
    Posts
    2

    Re: Looking up new bar codes and matching to product.

    Thanks....didn't work, but seems to be on correct concept. Problem is probably my fault for inadequate explanation.
    I've attached a slightly longer "products" sheet and highlighted the variable columns that might be used.
    For each color there are new barcodes that fit for each size of XS, SM, MD, and LG (and there is no new bar code for XL). These are on the sheet for EACH color...I include three colors vertically in column D: "Adopted", "Aloha Breeze" and "American Flags"...each with the sizes to match the colors on the "barcodes" sheet.
    You can see what I'm trying to do....make a formula that can be copied down the "New barcodes" column K on the "Products" sheet which has vertical orientation from the "barcodes" sheet which has horizontal orientation.
    A tough one!!
    thanks,

    rsuits

    code matching to products (2).xlsx

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 6
    Last Post: 06-25-2009, 07:39 PM
  2. [SOLVED] I have two columns (A) and (G) that have like product codes however
    By [email protected] in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 08-07-2006, 01:05 PM
  3. Replies: 1
    Last Post: 08-04-2006, 03:25 PM
  4. Replies: 1
    Last Post: 08-04-2006, 03:25 PM
  5. matching codes between 2 item codes
    By JChan in forum Excel General
    Replies: 1
    Last Post: 10-15-2005, 01:05 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1