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.
Bookmarks