Find any one of a list of terms, in a single string of terms

I have a long list of websites and I want to know if any of them fall within a single complicated url. So is there a function where I can ask something like... are any of these items in this list, in this single complicated string? I can't parse the url's as they are not all www.etc...

Thanks,

Brad

1) list all the urls in column A
2) list the search strings in column B
3) in C1 put this formula and then copy down:

=ISNUMBER(MATCH("*" & B1 & "*",$A:$A, 0))

You will get a series of TRUE/FALSE answers for the items that match.

If your list of websites is in column A and the sections you want are in column B (say B1:B3), then try:

=SUMPRODUCT(--ISNUMBER(SEARCH($B$1:$B$3,A1)))>1

to get TRUE if match found.

if you want to know which part was matched:

=SUMPRODUCT(--ISNUMBER(SEARCH($B$1:$B$3,A1)),ROW($B$1:$B$3)-ROW($B$1)+1)

will give you the item number from B1:B3 that matched.

Try:

=SUMPRODUCT(--ISNUMBER(SEARCH($F$2:$F$8,A2)))>=1

copied down... I had forgotten the = in >= before....

try in b2
=LOOKUP(2^99,SEARCH($F$2:$F$8,A6))>0
or
=NOT(ISNA(LOOKUP(2^99,SEARCH($F$2:$F$8,A2))))

the first one, martin, doesn't work correctly....

Based on my original suggestion, put this in D2 and press CTRL-SHIFT-ENTER to confirm it and activate the array:

=OR(ISNUMBER(MATCH("*" & $F$2:$F$8 & "*", A2, 0)))

...or

=OR(ISNUMBER(SEARCH("*" & $F$2:$F$8 & "*", A2)))

oops a2 not a6
=LOOKUP(2^99,SEARCH($F$2:$F$8,A2))>0
=NOT(ISNA(LOOKUP(2^99,SEARCH($F$2:$F$8,A2)))) and i suppose its in D2