+ Reply to Thread
Results 1 to 4 of 4

If isnumber search and vlookup n/a and false errors.

  1. #1
    Registered User
    Join Date
    04-16-2019
    Location
    Lincoln
    MS-Off Ver
    2010
    Posts
    26

    If isnumber search and vlookup n/a and false errors.

    Good evening members.

    I'm using a formula to check if cell ($L$2) contains specific text. Based on result formula vlookups from different lists. Everything works fine.
    Just if there is no results to show by text in $L$2 Then i'm getting a N/A error.
    If there is no text at all in $L$2 then getting false error.

    I tried to implement iferror or isna inside this formula but nothing works.
    Also maybe SEARCH("*"&"*",$L$2) is not good enough to check if there is anything typed in $L$2.

    Please Login or Register  to view this content.
    Any ideas how to remove this N/A and FALSE error?

  2. #2
    Forum Guru
    Join Date
    09-10-2017
    Location
    Chippenham
    MS-Off Ver
    365
    Posts
    8,740

    Re: If isnumber search and vlookup n/a and false errors.

    How about
    =IFERROR(IF($L$2="","",IF(OR(ISNUMBER(SEARCH("500-",$L$2)),ISNUMBER(SEARCH("800-",$L$2)),ISNUMBER(SEARCH("801-",$L$2))),VLOOKUP(G7,B:C,2,FALSE),VLOOKUP(G7,C:F,4,FALSE))),"")

  3. #3
    Registered User
    Join Date
    04-16-2019
    Location
    Lincoln
    MS-Off Ver
    2010
    Posts
    26

    Re: If isnumber search and vlookup n/a and false errors.

    Quote Originally Posted by Fluff13 View Post
    How about
    =IFERROR(IF($L$2="","",IF(OR(ISNUMBER(SEARCH("500-",$L$2)),ISNUMBER(SEARCH("800-",$L$2)),ISNUMBER(SEARCH("801-",$L$2))),VLOOKUP(G7,B:C,2,FALSE),VLOOKUP(G7,C:F,4,FALSE))),"")
    Brilliant. Didn't know you can use OR with multiple criteria.
    This helped me to fix couple other formulas. Thanks a lot.

  4. #4
    Forum Guru
    Join Date
    09-10-2017
    Location
    Chippenham
    MS-Off Ver
    365
    Posts
    8,740

    Re: If isnumber search and vlookup n/a and false errors.

    You're welcome & thanks for the feedback.

+ 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 function with ISNumber(Search()) and Vlookup
    By dango000 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 04-07-2020, 10:18 AM
  2. Replies: 6
    Last Post: 09-19-2019, 09:12 PM
  3. 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
  4. [SOLVED] If isnumber search function returning false
    By hawkwolf in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 08-14-2018, 02:36 PM
  5. 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
  6. COMBINATION - ISNUMBER, SEARCH VLOOKUP - Experts Please!
    By Sgroff in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-01-2017, 12:04 PM
  7. Replies: 3
    Last Post: 11-21-2011, 06:44 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