+ Reply to Thread
Results 1 to 4 of 4

Find specific Text and return a value

  1. #1
    Forum Contributor
    Join Date
    02-12-2008
    Location
    Doha-Qatar
    MS-Off Ver
    Excel 2007
    Posts
    137

    Find specific Text and return a value

    Hello Friends

    I am trying to find a code to do the following:

    If A1 is blank or it contains any of the following Texts (Reporting) (Level) then the result should be 2 otherwise the result should be 1

    Can you please help; I tried using Find and Search functions but in vain

    Thanks

  2. #2
    Forum Expert Ron Coderre's Avatar
    Join Date
    03-22-2005
    Location
    Boston, Massachusetts
    MS-Off Ver
    2013, 2016, O365
    Posts
    6,996

    Re: Find specific Text and return a value

    Is this something you can use?
    Please Login or Register  to view this content.
    Ron
    Former Microsoft MVP - Excel (2006 - 2015)
    Click here to see the Forum Rules

  3. #3
    Forum Contributor
    Join Date
    02-12-2008
    Location
    Doha-Qatar
    MS-Off Ver
    Excel 2007
    Posts
    137

    Re: Find specific Text and return a value

    Thanks Ron,

    The code returned 1 even when A1 does not contain the word (Reporting) or (Level).

    A1 is a full sentence in which the word (Reporting) may or may not appear; basically I am trying to combine IF with Find to get 1 or 2

    Thanks

  4. #4
    Forum Expert Ron Coderre's Avatar
    Join Date
    03-22-2005
    Location
    Boston, Massachusetts
    MS-Off Ver
    2013, 2016, O365
    Posts
    6,996

    Re: Find specific Text and return a value

    OK...A1 containing a sentence makes a big difference.
    Try this regular formula:
    Please Login or Register  to view this content.

+ Reply to Thread

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