On Wednesday, August 28, 2013 11:14:04 PM UTC-7, Claus Busch wrote:
Hi Howard,



Am Wed, 28 Aug 2013 19:23:55 -0700 (PDT) schrieb :



=IF(SUMPRODUCT(--($A$8:$A$40=B5)*($B$8:$M$40=B4))<0,"YES","NO")



that only works, if both search strings are in the same row in your

ranges.

Try:

=IF(COUNT(FIND(B4,B8:M40))*COUNT(FIND(B5,A8:A40)) 0,"Yes","No")

And enter the array formula with CTRL+Shift+Enter


Regards

Claus B.

Excellent point!

Thanks Claus.

Regards,
Howard