Search 3 Columns for 1 Word

[JeannetteE]

Hi,

I want to search more than one column for a single string, I can do it for one column but having a problem over 3 columns without having to add extra columns and do it individually then do an If statement for the final column.

This works for a single column =IFERROR(IF(SEARCH("*ABCD*",O3,1),"Yes"),"")

Then I tried this but get an Error =IF((OR(SEARCH("*ABCD*",N5,1), SEARCH("*ABCD*",O5,1),SEARCH("*ABCD*",P5,1),SEARCH("*ABCD*",Q5,1))),"Yes", "")

Any help will be greatly appreciated

 

[Fluff]

How about
=IF(ISNUMBER(MATCH("*abcd*",N5:Q5,0)),"Yes","")

 

[JeannetteE]

How about
=IF(ISNUMBER(MATCH("*abcd*",N5:Q5,0)),"Yes","")

Thank you so much! I didn't realize I could use the ISNUMBER Function. It's so easy when you know what your doing lol

 

[Fluff]

You're welcome & thanks for the feedback.