Try...
=IF(OR(ISNUMBER(FIND({"Smith","Jones"},B1))),"Mine ","Not Mine")
OR
=IF(OR(ISNUMBER(FIND(A1:A2,B1))),"Mine","Not Mine")
OR
=IF(B1<"",IF(OR(ISNUMBER(FIND(A1:A2,B1))),"Mine", "Not Mine"),"")
....where A1:A2 contains your list of names. The last two formulas need
to be confirmed with CONTROL+SHIFT+ENTER, not just ENTER. Also, the
last formula contains an additional IF statement to return a blank when
B1 is empty.
Hope this helps!
In article ,
toy4x4 wrote:
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
|