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

1. ## 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. ## 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. ## Re: If isnumber search and vlookup n/a and false errors.

Originally Posted by Fluff13
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. ## Re: If isnumber search and vlookup n/a and false errors.

You're welcome & thanks for the feedback.

#### Thread Information

##### Users Browsing this Thread

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

#### 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