=IF(ISNUMBER(SEARCH("LV-1";D2));"substring_found";"substring not
found")

HTH
Kostis Vezerides


Andis Cirulis wrote:
hey,

I`ve excel function

=SEARCH("LV-1";D2)

if search text LV-1 is not found - it returns #VALUE

how can I handle this #VALUE ?

=IF(SEARCH("LV-1";D2);"substring_found";"substring not found")

is not working (#VALUE returned in false case)

I believe this is simple, just cannot think of any solution..

Thanks,
Andis