HELP! Corrupted files

If you have a list of incorrect/correct names then a vlookup will work for you as in the attached sample.
I have made a table of such in columns E & F.
This will work well if you have multiple occurrences of the same name, but if every name is different it won't be of help.



Edit: Why is this file so huge?