+ Reply to Thread
Results 1 to 3 of 3

Using OR Function Within ISNUMBER(SEARCH()) Function

  1. 09-29-2011, 05:43 PM #1
    JonnyBoy333
    JonnyBoy333 is offline
    Registered User
    Join Date
    05-27-2008
    Posts
    28

    Using OR Function Within ISNUMBER(SEARCH()) Function

    Ok basically I'm trying to create an if-then formula that will look for one of two text strings in a cell and then return a specified value regardless of which text string it finds.

    This is what I have so far, it makes sense to me but excel doesn't seem to like it.

    =IF(ISNUMBER(SEARCH(OR("BT", "BIBTIGHT"), F10613))), "CYCLING BIBTIGHT", 0)
    Reply With QuoteRegister To Reply
  2. 09-29-2011, 05:46 PM #2
    daddylonglegs
    daddylonglegs is offline
    Forum Expert daddylonglegs's Avatar
    Join Date
    01-14-2006
    Location
    England
    MS-Off Ver
    2016
    Posts
    14,675

    Re: Using OR Function Within ISNUMBER(SEARCH()) Function

    Try this version.....

    =IF(COUNT(SEARCH({"BT","BIBTIGHT"},F10613)),"CYCLING BIBTIGHT",0)
    Audere est facere
    Reply With QuoteRegister To Reply
  3. 09-29-2011, 06:09 PM #3
    JonnyBoy333
    JonnyBoy333 is offline
    Registered User
    Join Date
    05-27-2008
    Posts
    28

    Re: Using OR Function Within ISNUMBER(SEARCH()) Function

    Awesome, that worked. Thanks a bunch.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1