#VALUE! Error inside SEARCH function nested in IF function that needs to be extended if possible

Question

Hi all,

Thanks for looking at my post even if its not too interesting it still important for me to fix it because I need to extend the function so much. 

Instead of

"IT'S Q" - I'll have =HYPERLINK((CONCATENATE("http://maps/pdf/Q/C_and_DO/",I87,".pdf")),I87)

"IT'S NOT Q" - I'll have =HYPERLINK((CONCATENATE("http://maps/pdf/B/C_and_DO/",I87,".pdf")),I87)

and I guess will be good to start with no error since . I tried my own fixes but doesn't solve the error.

Thanks for any suggestion,

Dan Tabla

Answer 1

The SEARCH function gives an error if it doesn't find the string you're looking for.

Try it like this:

=IF(IFERROR(SEARCH("q",F87,1),0)<>0,"IT'S Q","IS NOT Q")

Answer 2

Thanks a lot mr. Murray, it solved my problem. Apologize for the delayed answer but I had to test it before confirming.