SEARCH and arrays

[Janie]

Is there any way to use SEARCH with an array? Is there some other formula?
Here's the goal: cells D1 thru M1 have a text string. Cells A1 through A50
have text strings. Some of the items in D1:M1 may be substrings of items in
A1:A50. I am trying to come up with a method to go through the list D1:M1
and tell me if any of the words are embedded in A1:A50.

Make sense?

all ideas appreciated

Janie

 

[Ron Rosenfeld]

Is there any way to use SEARCH with an array? Is there some other formula?
Here's the goal: cells D1 thru M1 have a text string. Cells A1 through A50
have text strings. Some of the items in D1:M1 may be substrings of items in
A1:A50. I am trying to come up with a method to go through the list D1:M1
and tell me if any of the words are embedded in A1:A50.

Make sense?

all ideas appreciated

Janie

Not sure exactly what you want.

But to check to see if a word is in an array, something like:

=COUNTIF($A$1:$A$50,"*"&D1&"*") > 0

will be true if the word in D1 is found in any of the strings in A1:A50

So you could put that formula in D2, and fill across to M2.

--ron