I am trying to use vlookup to update two columns in a master workbook using the information from another sheet. The problem I'm having is that there are slight differences in some names in the two sheets (ex. including a period after a middle initial). Because of this, the formula cannot find the name correctly and the formula does not work. I am relatively new to excel and just know the basics. Any suggestions for fixing the names so that they are the same other than doing every one manually?
Bookmarks