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.
Any ideas how to remove this N/A and FALSE error?
Bookmarks