Nesting IF statements - comparing text

Closed
JagMan Posts 3 Registration date Thursday January 27, 2011 Status Member Last seen September 30, 2013 - Sep 30, 2013 at 03:31 PM
Hello,

i am trying to match 2 columns of names. the issue is that the one column is a full name and the other is only a partial name, usually first or last name. the other issue that comes into play is that some of the names may have a special character in the name like a hyphen or dash or ampersand. i would like it to tell me whether it is an exact match, partial match or no match at all. i can get 2 out of the 3 to work. example what i need is below.

ColumnA ColumnB ColumnC
smith smith exact match
smith jones no match
karl smith smith partial match
berg/jones berg partial match