On Thursday, August 29, 2013 5:32:51 PM UTC-7, Ron Rosenfeld wrote:
On Thu, 29 Aug 2013 05:44:41 -0700 (PDT), wrote:





Also:



=IF((COUNTIF(Range_1,"*"&A1&"*")+COUNTIF(Range_2," *"& B1&"*"))=2,"Yes","No")



Thanks, Ron.



I am puzzled with the "*"&A1&"*"



Googled and looked in my J. Walkenbach references but can't find a "...here's what this does."



Regards,

Howard



1. See Claus note and change as he suggested:



=IF((COUNTIF(Range_1,"*"&A1&"*")*COUNTIF(Range_2," *"& B1&"*"))0,"Yes","No")



2. In the COUNTIF criteria, wild cards are allowed. You will find that documented under HELP for the COUNTIF function.

Okay, thanks.

Howard