"IF" Statement - find text within Range

Hey Guys,

I am having a complete "dummy" attack. I need an "IF" formula that will locate text within a row of cellsand will return a "true/false". Basically a I have a large data set with about 30 columns. If the word "Yes" appears in any of the rows of data, then the arguemnt should equal "YES" in B2.

I have attached a file that should be easier to understand. Thanks in advance!

Mike