+ Reply to Thread
Results 1 to 5 of 5

Categorizing products (search product names in a range to add the right category)

  1. #1
    Registered User
    Join Date
    12-16-2012
    Location
    Amsterdam
    MS-Off Ver
    Excel 2003
    Posts
    4

    Categorizing products (search product names in a range to add the right category)

    Hey guys,

    I need to categorize many, many products in a column (missing data in the first column). I would like to check a second sheet and add the corresponding category name in the first sheet (total of 9 categories)

    See attachment. i have a dealine tomorrow so any help is extremely welcome!!

    Regards, Kurt
    Attached Images Attached Images

  2. #2
    Forum Contributor dogberry's Avatar
    Join Date
    07-15-2012
    Location
    Wales, UK
    MS-Off Ver
    Excel 2010
    Posts
    624

    Re: Categorizing products (search product names in a range to add the right category)

    Hi

    Can you post a sample worksheet so we can see the layout etc dont post confidentail information


    To Attach a File:

    1. Click on Go Advanced
    2. In the frame Attach Files you will see the button Manage Attachments
    3. Click the button.
    4. A new window will open titled Manage Attachments - Excel Forum.
    5. Click the Browse... button to locate your file for uploading.
    6. This will open a new window File Upload.
    7. Once you have located the file to upload click the Open button. This window will close.
    8. You are now back in the Manage Attachments - Excel Forum window.
    9. Click the Upload button and wait until the file has uploaded.
    10. Close the window and then click Submit.



    Chris
    Click my star if I helped Thanks

  3. #3
    Registered User
    Join Date
    12-16-2012
    Location
    Amsterdam
    MS-Off Ver
    Excel 2003
    Posts
    4

    Re: Categorizing products (search product names in a range to add the right category)

    Hi dogberry, I made an example doc with two (slightly simplified) sheets. Hope this helps! Thanks for the lightning fast reply

    Huug
    Attached Files Attached Files

  4. #4
    Forum Contributor dogberry's Avatar
    Join Date
    07-15-2012
    Location
    Wales, UK
    MS-Off Ver
    Excel 2010
    Posts
    624

    Re: Categorizing products (search product names in a range to add the right category)

    Hi

    Sorry had to go out on a job its my weekend for 24hr cover. Looking at your sheet I dont think its possible it would no be so bad if T = customer care end of story however looking at the list you have a few letters for customer care and 5 customer care so I cant see anyway of telling them apart.

    Chris

  5. #5
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,917

    Re: Categorizing products (search product names in a range to add the right category)

    not sure if this is what you want, but if the list on sheet2 was more conclusive with all the letters, then try something like this, copied down...

    =IFERROR(VLOOKUP(B29,'Category per product'!$A$2:$B$10,2,FALSE),"")

    NOTE: the file you uploaded indicates that you are using at least 2007, please update your profile accordingly. the above formula will not work in 2003 and its equivalent would have been...

    =IF(ISERROR(VLOOKUP(B29,'Category per product'!$A$2:$B$10,2,FALSE)),"",VLOOKUP(B29,'Category per product'!$A$2:$B$10,2,FALSE))
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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