Comparison of Values based on pattern Matching

Hi All,

I have to match values in two columns based on the similarities ...Can you please help me here...Attached the sheet...Column C has the matched answer as yes or no...Can you please help me here..




Thanks,
Arun

What rules are to apply:

tsobel SOBELT exact match on letters
mpetrizzi PETRIZZIM " "
jburford5 BURFORDJIM Partial match (ignoring numerics and IM)
jschwartz20 SCHWARTZJ Match ignoring numerics

Hi John,

There are two rules that I observe:

1) the last character is placed at the beginning from the first column for matching..
2) Based on similarity of characters (more than 75% similarity )results in a match or matching based on sounds (how the values based in the two columns sound like)..

Thanks,
Arun

Unfortunately, Excel does not do "sounds" !

But for Case !.

=IF(LEFT(A2,1)=RIGHT(B2,1),"Yes","No")

Fails for ..

jburford5 BURFORDJIM

Slightly more comprehensive

=IF(AND(LEFT(A2,1)=RIGHT(B2,1),MID(A2,2,LEN(A2)-1)=MID(B2,1,LEN(A2)-1)),"Yes","No")