Thread
:
A find formul looking at two named ranges for two strings
View Single Post
#
5
Posted to microsoft.public.excel.worksheet.functions
Ron Rosenfeld[_2_]
external usenet poster
Posts: 1,045
A find formul looking at two named ranges for two strings
On Wed, 28 Aug 2013 19:12:53 -0700 (PDT),
wrote:
If I have two named ranges, Range_1 and Range_2...
and
Cell A1 has a string that may or may not be in Range_1
and
Cell B1 has a string that may or may not be in Range_2
is there a formula that will return a YES if both strings are present in the respective named ranges or a NO if either string is not present in its respective range?
Say Range_1 is A2:A150, Range_2 is C2:J200.
Thanks,
Howard
Also:
=IF((COUNTIF(Range_1,"*"&A1&"*")+COUNTIF(Range_2," *"& B1&"*"))=2,"Yes","No")
Reply With Quote
Ron Rosenfeld[_2_]
View Public Profile
Find all posts by Ron Rosenfeld[_2_]