Thread: A find formul looking at two named ranges for two strings
View Single Post
  #9   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ron Rosenfeld[_2_] Ron Rosenfeld[_2_] is offline
external usenet poster
  
Posts: 1,045
Default A find formul looking at two named ranges for two strings
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.
Reply With QuoteReply With Quote