Check your other post.

Jay wrote:

The SEARCH and FIND functions in Excel allow me to find text strings within a
single cell. Is there a function that would allow me to search for a text
fragment in an array of cells? The text fragment may be embedded in a longer
string (i.e., it would likely not be an exact match), so I dont think that
the LOOKUP functions could be employed.
--
Jay

--

Dave Peterson