In .com, Fester
spake thusly:

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.

[(Dave Peterson had written:]

In Sheet1 cell B1:
=if(isnumber(match(a1,sheet2!a:a,0)),"Yes",""


Wes, in that case, use a -1 where Dave has a 0, as an arg to
the MATCH statement.

=if(isnumber(match(a1,sheet2!a:a,-1)),"Yes",""


However, you will run into problems if one name is, for example,
Steve Smith, and another (on Sheet2!) is Steve Smithson.

-dman-