I've got two files of teacher's class information that I need to merge. For
instance, in Column C includes the teachers' names in both files. however,
in FILE1 the names are listed lastname firstname (with no comma) while in
FILE2, the names are listed lastname, firstname (with comma). Of course, the
last names are not the same length from row to row. I need to get the column
D information from File1 and have it show up in Column D in File2. normally,
this would be a simple process of copying and pasting the information except
that there are some names that appear in one file and not both and some
teachers are listed on multiple rows in one file and a different number of
rows in the other file.

Any assistance would be greatly appreciated.