Results 1 to 8 of 8

Look for multiple strings in a cell

Threaded View

  1. #1
    Registered User
    Join Date
    03-06-2012
    Location
    seattle, USA
    MS-Off Ver
    Excel 2010
    Posts
    41

    Look for multiple strings in a cell

    Hi,

    I would like to check if any of 'n' strings in a cell and return "found" if any of the 'n' strings is found in the cell.

    Example:

    A1 contains - "MAYURI FOODS AND VIDEO REDMOND WA"

    A2 should display "found" if A1 contains one of the values "FOOD, APNA, UDUPI"

    I tried =IF(COUNTIF(B167,{"*MAYURI*","*APNA*","*UDUPI*"}),"found") . But it did not work.

    Can any one give me a solution to my requirement?

    Thanks in advance.
    Last edited by reddy14; 03-06-2012 at 05:30 PM.

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