Results 1 to 12 of 12

IF ISNUMBER SEARCH and OR with extra criteria?

Threaded View

  1. 11-12-2020, 02:20 PM #1
    Yeesha
    Yeesha is offline
    Registered User
    Join Date
    10-02-2020
    Location
    US
    MS-Off Ver
    2016 and Office 365
    Posts
    6

    IF ISNUMBER SEARCH and OR with extra criteria?

    Hello,
    I am trying to work my way through a formula using the following, but I'm getting the problem message.
    =IF(AND(ISNUMBER(SEARCH("CRI",B2)),ISNUMBER(SEARCH("won",L2))),ISNUMBER(SEARCH("Kickoff",L2)))),ISNUMBER(SEARCH("In Progress",L2))))),A2,"")
    I only want the content in Column A to return if it meets the Criteria of B and L with L being any of those three options.
    Any help is appreciated!
    Attached Files Attached Files
    Last edited by Yeesha; 11-17-2020 at 09:41 AM. Reason: Updated attached file
    Reply With QuoteRegister To Reply
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] search criteria like small(if(isnumber(find.. with any code
    By adeel1 in forum Excel Programming / VBA / Macros
    Replies: 31
    Last Post: 10-07-2019, 01:36 AM
  2. Isnumber(search........help!!
    By simont485 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 06-27-2019, 01:40 PM
  3. [SOLVED] If/IsNumber multiple search criteria. Does syntax accept "OR"?
    By onemoremile in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 08-03-2018, 05:36 PM
  4. If + isnumber + search + or
    By longhorn94 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 02-06-2018, 07:14 PM
  5. [SOLVED] Using IF ISNUMBER SEARCH with AND
    By larry11 in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 06-21-2017, 05:38 PM
  6. IsNumber Search
    By JamesArmitage in forum Excel General
    Replies: 5
    Last Post: 05-10-2016, 08:28 AM
  7. [SOLVED] Multiple Criteria Isnumber Search Array (with Attachment Example)
    By sweetrevelation in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 11-13-2013, 05:45 AM

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