Results 1 to 11 of 11

If/IsNumber multiple search criteria. Does syntax accept "OR"?

Threaded View

  1. #1
    Registered User
    Join Date
    10-08-2013
    Location
    United States, North Ameriac
    MS-Off Ver
    Excel 2010, Excel 2007, Excel 2013
    Posts
    58

    If/IsNumber multiple search criteria. Does syntax accept "OR"?

    Hi All:

    I have a formula that I am working to tweak to search for multiple text.
    • I want to look in a table for specific texts. Example: "Pol", "Occl", "Hap", and "Div"
    • If the texts are found anywhere in the searched cells, I want the entire cell data returned.


    This is the formula that is working for me for just 1 search criteria. For example:

    ARRAY FORMULA =Iferror(Index($G1:$AZ1,Small(If(IsNumber(Search("Pol",$G15:$AZ15)),Column($A$2:$AH$2)-Row($A$1)+1,Column($A$1))),"")
    I have tried putting "OR" after the iferror and dropping in the different specific texts...it bombs.

    Any help would be appreciated!

    Thanks
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Multiple search terms: (ISNUMBER(SEARCH(". VALUES",1:1))),FALSE)
    By Schultze in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 03-22-2018, 06:40 AM
  2. [SOLVED] Formula: =IF((ISNUMBER(SEARCH("172.29.90.",$A3)))*(ISNUMBER(SEARCH("00-00-85",$F3))),"MF
    By dude6571 in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 11-04-2017, 07:36 AM
  3. Replies: 12
    Last Post: 11-03-2017, 11:22 AM
  4. [SOLVED] Syntax for an "IF AND ISNUMBER SEARCH" function
    By EFD in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 10-31-2017, 09:29 AM
  5. Replies: 2
    Last Post: 07-24-2017, 02:19 AM
  6. 7 nested IF statements with a SEARCH added IF(ISNUMBER(SEARCH({"INSUR","AP REFUND"}
    By michaelproctor001 in forum Excel Formulas & Functions
    Replies: 15
    Last Post: 12-10-2013, 02:13 PM
  7. Replies: 6
    Last Post: 02-25-2013, 03:16 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1