Combining IF with Search Function

[searchingforhelp]

Hello,

I am attempting to no avail combine two formulas. My goal is to locate a specific word in a cell that contains other characters/ words by utilizing the SEARCH function. If the word is located in a cell, I would like another cell to indicate "Found". If the word is not located in the cell, it will indicate "Not Found"

Below are two function I am attempting to combined:
=IF(SEARCH(B5,B2),"Found")
=IFERROR(SEARCH(B5,B2),"Not Found").

Below (or attached) is an image I am referencing with the formulas above.

Lastly, is there a way in using the functions above to search multiple columns for the same word? I written a separate sentence in F2 for an example.

Greatly appreciate any help I can get and if possible can the formulas be separated per question so I can distinguish between the formulas for learning purposes.

Thanks!!

 

[Fluff]

How about

=if(isnumber(search(" "&B5&" "," "&B2&" ")),"Found", "Not found")

This will distinguish between run & running, as long as there is no punctuation within the phrase.

 

[searchingforhelp]

How about

=if(isnumber(search(" "&B5&" "," "&B2&" ")),"Found", "Not found")

This will distinguish between run & running, as long as there is no punctuation within the phrase.

Thank you Fluff, truly appreciate it. I noticed if the word "run" is proceeded by "run)". The formula result was "Not Found". Is there a way to override these type of instances? I noticed when using only =IFERROR(SEARCH(B5,B2),"Not Found"), it located the word "run" within "run)" however as a result it gave a number number.

 

[Fluff]

You can use

=if(isnumber(search(B5,B2)),"Found", "Not found")

But that will return true for words words like runt, brunt etc. Not sure if that's a problem.

 

[searchingforhelp]

You can use

=if(isnumber(search(B5,B2)),"Found", "Not found")

But that will return true for words words like runt, brunt etc. Not sure if that's a problem.

Perfect! This worked! Before I check off, can you provide insight regarding my second question in the first post. How can I use this formula to search multiple columns? For example, search in column B2 and F2 for the word run. Thanks again for taking your time to address my questions.

 

[Fluff]

Maybe

=if(or(isnumber(search(B5,B2)),isnumber(search(B5,B2))),"Found", "Not found")

 

[searchingforhelp]

Maybe

=if(or(isnumber(search(B5,B2)),isnumber(search(B5,B2))),"Found", "Not found")

It worked! Thank you so much

 

[Fluff]

You're welcome & thanks for the feedback.