Results 1 to 13 of 13

Searching for multiple words in a cell

Threaded View

  1. #1
    Registered User
    Join Date
    05-02-2011
    Location
    New York
    MS-Off Ver
    Excel 2003
    Posts
    7

    Searching for multiple words in a cell

    Hello,

    I'm trying to search for a list of words within a cell that contains text and have those words displayed in the column adjacent to it.

    For example:

    A1: The cat in the hat.
    A2: The dog in the hat.
    A3: The walrus in the hat.
    A4: The cat on the mat.
    A5: The cat and dog on the mat.

    B1:B5 contains the search terms I'm looking for:
    B1: Cat
    B2: Dog
    B3: Walrus
    B4: Hat
    B5: Mat

    I would like C1:C5 to show whether the search terms in B1:B5 are found in A1:A5, and then display those results (ie C1 should show 'cat and hat' and C2 should show 'dog and hat' and C5 should show 'cat, dog and mat').

    Currently I'm using =IF(COUNT(SEARCH({"Cat","Dog"},A1)),"Cat","") but this formula isn't particularly useful for my purposes since it is TRUE/FALSE rather than returning the actual search term.

    I would be very grateful for any help - thank you so much in advance!
    Last edited by NBVC; 05-04-2011 at 01:35 PM. Reason: Assumed solved based on rep given on last post.

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