Search rows for words and return "Yes"

Thanks for the speedy reply
That works, however the spreadsheet is populated daily and averages 300 lines a day is there a way of doing this for every line without specifying b1, b2, b3, etc?

Thanks in advance