Excel likes exact matches--just like most mechanized things.

But maybe...
=if(isnumber(match("*"&a1&"*",sheet2!a:a,0)),"Yes" ,"")


Fester wrote:

Thanks Dave but that does not appear to work.
For example Sheet1! cell A1 has the following name proceeded by a
space: Mike Comrie
Somewhere in Sheet2! column A is the name: Mike Comrie C
I need this to be considered a match. ie. if whatever is in Sheet1!
cell A1 is found in any position of a cell in colum A1 of Sheet2! then
that is a match and Sheet1! cell B1 would be set to yes.
Thanks to all that help.
Wes

--

Dave Peterson