SEARCH for a cell value within the string of a list of cells

I have values in column A and similar values in column B. I want to be able to find if the string in A1 is found anywhere within any of the cells in column B. This may not be the SEARCH function, but I thought it could be.

For example:

Column A contains values such as {cat, dog, bird}
Column B contains values such as {eee, ddd, bbb, acat}

I would get a return of TRUE for cat as it appears within a string in column B.


Thanks in advance

Try..

Please Login or Register  to view this content.