How can I write up a formula that utilizes search referencing two named dynamic ranges.


Here are the base formulas I found from another site:
=IF(SUMPRODUCT(--(NOT(ISERR(SEARCH({"Gingrich","Obama","Romney"},C1)))))>0,"1","")
or
=IF(SUMPRODUCT(--(NOT(ISERR(SEARCH($A$1:$A$3,C1)))))>0,"1","")
The dynamic named range formula I use are:
=OFFSET(Calcs!$A$1,0,0,COUNTIF(Calcs!$A:$A,"?*"))
as named range "range_list1"
and
=OFFSET(Calcs!$B$1,0,0,COUNTIF(Calcs!$B:$B,"?*"))
as named range "range_list2"


I thought I could replace the range in the base formulas with just one named range for test purposes but I get a zero.
=IF(SUMPRODUCT(--(NOT(ISERR(SEARCH(range_list1,C1)))))>0,"1","")