+ Reply to Thread
Results 1 to 3 of 3

Search one cell by multiple criteria to return corresponding multiple text

  1. #1
    Registered User
    Join Date
    04-28-2014
    Location
    London, England
    MS-Off Ver
    Excel 2010
    Posts
    7

    Search one cell by multiple criteria to return corresponding multiple text

    Hi,

    I have a column DATA containing one-letter abbreviations for fruits. I'd like to search each cell in DATA for abbreviations, and return the long-hand text for each (sometimes multiple) fruit into column AIM. See DATA and AIM pasted below, or attached file.

    I've been trying this...
    =IF(ISNUMBER(SEARCH("a",A2)),"apple ",IF(ISNUMBER(SEARCH("c",A2)),"cherry",""))
    ...but it only returns the first abbreviation - please could someone suggest how to adapt this to return multiple results?

    Many thanks!

    DATA AIM
    a apple
    c cherry
    ac apple cherry
    ca cherry apple
    c cherry

    decode_fruit_abbrev.xlsx

  2. #2
    Forum Contributor
    Join Date
    08-02-2012
    Location
    Pune
    MS-Off Ver
    Office 365 (Win 10)
    Posts
    489

    Re: Search one cell by multiple criteria to return corresponding multiple text

    Sorry, wrong answer. Pls ignore
    Attached Files Attached Files
    Please make the Post as solved, when you get your answer & Click * if you like my suggestion

  3. #3
    Forum Expert
    Join Date
    09-01-2012
    Location
    Norway
    MS-Off Ver
    Office 365
    Posts
    2,844

    Re: Search one cell by multiple criteria to return corresponding multiple text

    Like this? Note that these are array formulas, they need to be entered with Ctrl + Shift + Enter.
    Attached Files Attached Files
    <----- If you were helped by my posts you can say "Thank you" by clicking the star symbol down to the left

    If the problem is solved, finish of the thread by clicking SOLVED under Thread Tools
    I don't wish to leave you with no answer, yet I sometimes miss posts. If you feel I forgot you, remind me with a PM or just bump the thread.

+ 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. Search cell for multiple text , return comma separated text in separate cell if found
    By dangerdoug in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-01-2013, 01:52 PM
  2. Replies: 1
    Last Post: 04-08-2013, 07:07 PM
  3. Replies: 5
    Last Post: 06-21-2012, 10:36 AM
  4. User Form to Search multiple Criteria to return multiple Results
    By Calieth in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 08-16-2011, 11:57 AM
  5. Return multiple cell references based on a search criteria
    By ruddocg in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 11-30-2006, 07:49 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