Ok, this works to start off:

=IF(FIND("Smith",B1),"Mine","Not Mine")

Problem is when Smith is not in the name I get #VALUE instead of "Not Mine".

Then how to do nester ORs for Smith, Jones, etc.

Cause this doesn't work:

=IF(OR(FIND("Smith",B1),FIND("Jones",B1)),"Mine"," Not Mine")

I just get #VALUE