Results 1 to 4 of 4

Search for specific text in a row

Threaded View

rudolphe Search for specific text in a... 01-24-2011, 11:33 AM
ChemistB Re: Search for specific text... 01-24-2011, 11:38 AM
NBVC Re: Search for specific text... 01-24-2011, 11:42 AM
rudolphe Re: Search for specific text... 01-24-2011, 11:51 AM
  1. #1
    Registered User
    Join Date
    02-25-2009
    Location
    Philadelphia, PA
    MS-Off Ver
    Excel 2007
    Posts
    4

    Search for specific text in a row

    I'm trying to search for specific text in a row and output a certain text if it is found. Like searching for a match but a "contains text" match instead of a total match.

    I tried using "=IF(SUMPRODUCT(ISNUMBER(SEARCH("dog",A:A,))),"found,""notfound")"

    Any suggestions?
    Last edited by rudolphe; 01-24-2011 at 11:53 AM.

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