Nesting IF statements - comparing text

[Closed]
Report
Posts
3
Registration date
Thursday January 27, 2011
Status
Member
Last seen
September 30, 2013
-
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


Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!