Column of words as filter for column of sentences

Hi

I have excel for mac 2011

I have a column of sentences ( A ) and a column of words ( B ). I want a new column ( C ) in which sentences from A are copied onto only if they contain one or more of the words in column B.

I want the sentences in column C to appear with no cells in between them.

I have tried these formulas:

=IF(SUMPRODUCT((ROWS($B$2:$B$4)*(COUNTIF(A2,"*"&$B$2:$B$4&"*"))))>0,A2,"")

=IF(OR(ISNUMBER(SEARCH($B$2:$B$4,A2))),A2,"")

=IF(COUNT(INDEX(SEARCH($B$2:$B$4,A2),0)),A2,"")

=IFERROR(INDEX(A:A,SMALL(IF(FREQUENCY(IF(ISNUMBER(SEARCH(TRANSPOSE($B$2:$B$4),$A$2:$A$5)),ROW($A$2:$A$5)),ROW($A$2:$A$5)),ROW($A$2:$A$5)),ROWS($2:2))),"")


but i keep getting "formula contains error". Any ideas for a solution?


Regards,
Njaal, Norway.