Finding Possible Mismatch between columns

So I have two columns of data, say A and C. I did a VLookUp and Highlighted the mismatches in column A(yellow colour). I now have to add a comment to the highlighted cell in A, that gives the mismatch name as present in column C. For example if the mismatch highlighted in column A is "Joel", and the same is written in column C as "Joell" then the comment over the cell in column A must read "In column C as: Joell". I have tried and searched a lot, but to no avail. Is there anyone who could give me a VBA code to do the same?

NOTE: Column A and column C are ordered differently and have different number of cells.

I'm having a hard time picturing what you're asking. Since as far as Excel would care "Joel" would not only be a mismatch to "Joell", but also to "Sam", "Gorge", "Bob", ... and pretty much anything other than "Joel".

that asside, the VBA to update cell comments would look something like this:

Please Login or Register  to view this content.

I believe you are going to have a hard time nailing down what “closest” really means when you’re talking about misspellings.

For example is "Joell" or "Jole" a closer match to "Joel"?

Two possible avenues for you to look into if you’re the programmer type are:

• Damerau-Levenshtein distance
• Trie approximate string matching

However these two are so far removed from out of the box Excel that you’re going to have quite a bit of heavy lifting yet to do… and also likely to end with a O(N²) algorithm