Hello all,
Is there any quick methods to convert similar text on different sheets so that one matches the other.
For example in the attached workbook, I have used a formula to lookup values in sheet 1. However, it returned errors in sheet 2 as the reference cells have spelling errors and blanks.
How do I ensure that Sheet 2 matches Sheet 1 or vice versa. I essentially would like a formula / method that allows the Name column on both sheets to match.
Bookmarks