Formula to lookup multiple text values in multiple columns

Hi,

I am trying too use the search funtion to lookup a text string in multiple columns and return a value if it finds it in any column, this works fine in 1 column =IF(ISERROR(SEARCH("*blah*",D1)),0,1) but if i try and serach multiple columns at once it doesn't work... ie =IF(ISERROR(SEARCH("*ppa*",A1:S6000)),0,1)

Any help would be appreciented.

Thanks

K

Thats looks like it's only searching for multiple cells, not multiple columns??

Maybe something like this?

=IF(ISERROR(SEARCH("*blah*",D1)),0,1)+OR(IF(ISERROR(SEARCH("*blah*",E1)),0,1))