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.
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2