+ Reply to Thread
Results 1 to 6 of 6

If isnumber search function returning false

  1. #1
    Registered User
    Join Date
    08-14-2018
    Location
    Texas
    MS-Off Ver
    2013
    Posts
    6

    If isnumber search function returning false

    Hello I am new to this forum and mostly self taught on excel. I am trying to learn different functions to help speed up my workflow and have discovered the =IF(ISNUMBER(SEARCH function. However when I try it out, it keeps saying false. Even if I just break it down to search it is still returning false and a bit confused by this.

    I started with =IF(ISNUMBER(SEARCH("EOC",$G2)),"Yes","No") to test it out to make sure it works but returns false. G2 cell contains "CDC, EOC C/W"

    When I reduced it down to =SEARCH(K4,G2) K4 having "EOC" in it, it still returned false.

    If it matters, using excel 2013.

  2. #2
    Forum Expert CK76's Avatar
    Join Date
    06-16-2015
    Location
    ONT, Canada
    MS-Off Ver
    Office 365 ProPlus
    Posts
    5,720

    Re: If isnumber search function returning false

    I'd recommend uploading sample file.

    I suspect, that you might have non-printing characters somewhere between E & O or O & C in G2.
    Which causes SEARCH on "EOC" to return false.
    “Progress isn't made by early risers. It's made by lazy men trying to find easier ways to do something.”
    ― Robert A. Heinlein

  3. #3
    Registered User
    Join Date
    08-14-2018
    Location
    Texas
    MS-Off Ver
    2013
    Posts
    6

    Re: If isnumber search function returning false

    Ok so when I went to create a sample, it works. So obviously it isn't the formula but a setting in the excel sheet somehow?

    EDIT: by sample I mean I opened up a fresh excel to create a mini version of what I was working on. The original is a table created by somebody else previously and I have been trying to streamline it.

  4. #4
    Forum Expert CK76's Avatar
    Join Date
    06-16-2015
    Location
    ONT, Canada
    MS-Off Ver
    Office 365 ProPlus
    Posts
    5,720

    Re: If isnumber search function returning false

    Try doing following.

    In some out of way range enter following formula.
    =MID($G$2,COLUMN(A1),1)

    And copy across. If you see EOS in contiguous cells, then it's something else that's wrong with workbook. If you see some seemingly blank cells in between...
    It's likely non-printing character that needs to be removed from string in G2 (Using... TRIM, CLEAN and/or SUBSTITUTE).

  5. #5
    Registered User
    Join Date
    08-14-2018
    Location
    Texas
    MS-Off Ver
    2013
    Posts
    6

    Re: If isnumber search function returning false

    Now I am pretty sure it is the workbook. It is giving me a certificate error when I paste in that formula in some out of the way place nearby ("This application experienced an internal error loading the SSL libraries") I am just going to recreate the table in a fresh excel. Thank you for the help ^.^

  6. #6
    Forum Expert CK76's Avatar
    Join Date
    06-16-2015
    Location
    ONT, Canada
    MS-Off Ver
    Office 365 ProPlus
    Posts
    5,720

    Re: If isnumber search function returning false

    You are welcome and good luck.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. IF AND ISNUMBER SEARCH Function. Keeps returning false value even if true.
    By joshuarobbins in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 08-05-2019, 02:53 AM
  2. 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
  3. ISNumber combined with MID returning FALSE if blank
    By Muhammad Atif Gul in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 07-08-2017, 11:20 PM
  4. [SOLVED] IF(ISNUMBER(SEARCH function
    By NickT83 in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 03-16-2014, 10:18 AM
  5. [SOLVED] ISNUMBER function in formula not returning expected value
    By lukela85 in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 11-09-2013, 05:12 PM
  6. Replies: 3
    Last Post: 11-21-2011, 06:44 AM
  7. ISNUMBER(SEARCH Function
    By somesoldiers in forum Excel General
    Replies: 2
    Last Post: 07-14-2009, 10:49 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