+ Reply to Thread
Results 1 to 2 of 2

Search Multiple Word String and Return Categories

  1. #1
    Registered User
    Join Date
    01-14-2016
    Location
    Atlanta, GA
    MS-Off Ver
    2013
    Posts
    1

    Search Multiple Word String and Return Categories

    Hello,

    Completely lost on this one. I'm trying to parse through a string with multiple items, compare each against a list of categories, and return which categories are included in the string. I've included an example:

    Categories:
    Berries Raspberries, Blueberries, Blackberries
    Tropical Fruit Star Fruit, Bananas
    Everyday Fruit Apples, Oranges


    List: Return:
    Apples, Bananas, Raspberries Everyday Fruit, Tropical Fruit, Berries
    Star Fruit Tropical Fruit
    Blueberries Berries
    Oranges, Blackberries Everyday Fruit, Berries
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    03-20-2015
    Location
    Primarily UK, sometimes NL
    MS-Off Ver
    Work: Office 365 / Home: Office 2010
    Posts
    2,405

    Re: Search Multiple Word String and Return Categories

    Welcome to the forum.

    Assuming your table represents columns A and B, put this in C2 and copy down:
    Formula: copy to clipboard
    Please Login or Register  to view this content.

    The only problem is that this doesn't put a comma between your categories. If you want the comma, you can replace the &" "& with &", "& but then you'll get results such as ', Tropical Fruit,' or 'Berries, ,' or 'Berries, , Everyday Fruit' - it's up to you which you prefer.

    Hope that helps.
    Regards,
    Aardigspook

    I recently started a new job so am a bit busy and may not reply quickly. Sorry - it's not personal - I will reply eventually.
    If your problem is solved, please go to 'Thread Tools' above your first post and 'Mark this Thread as Solved'.
    If you use commas as your decimal separator (1,23 instead of 1.23) then please replace commas with semi-colons in your formulae.
    You don't need to give me rep if I helped, but a thank-you is nice.

+ 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. [SOLVED] Search a string from a column, and return multiple values
    By newroads in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 08-11-2015, 03:43 PM
  2. Replies: 2
    Last Post: 05-14-2015, 01:30 PM
  3. Replies: 2
    Last Post: 08-05-2013, 04:45 PM
  4. Replies: 1
    Last Post: 04-08-2013, 07:07 PM
  5. Search for txt string in multiple cells, return row number(s)
    By kris10s7 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 09-25-2012, 11:06 PM
  6. Lookup then Search for text string and return multiple entries
    By tnewell2 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 09-24-2012, 12:11 PM

Tags for this Thread

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