Okay, I have 2 lists of names (lname, fname separate cells) for staff with
software at different points in the year. I need to compare the lists and
identify the differences. the catch is that lists come from different
sources, so Mike could be Michael and Jeff could be Jeff K. (middle initial).
I've gotten close a couple of times with some unique nested if's, match's,
index's and left's, but haven't quite gotten it right. Any help? Here a
sample of what data would look like. Thanks!

Jones Bob Jones Robert
Lind Mary Jones Michael
Smith Joe K Smith Joe
Young Bob Troy Mary