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

[Gochix2018]

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?

[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))),"")

[Gochix2018]

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.

[Fluff13]

You're welcome & thanks for the feedback.