Search for strings within a column of cells

[casey2]

I'm trying to determine a way to take a column of data, and search for matching strings within another column of data.

For example:

A : B
Hostname1 : AppX on Hostname4
Hostname2 : AppX on Hostname3
Hostname3 : AppX on Hostname1
Hostname4 : AppX on Hostname2

So, I want to determine which cells in Column B contain the text in Column A.

Thanks!

-Casey

[NBVC]

Perhaps something like:

=ISTEXT(LOOKUP(9.9999E+307,SEARCH(" "&$A$1:$A$10&" "," "&B1&" "),$A$1:$A$10))

adjust ranges to suit...

This should give TRUE if match found...

[casey2]

Beautiful - thank you so much!