I have 2 sheets one has the Employee name and Employee # the Other only has the Employee name but it does not always match Ex. Jones, Tim and Jones, Timothy or Jordan, Michael and Jordan, P. Michael.
How do I add the Employee #'s to the names that aren't exact.
Sheet 1 has
A, B, C,
Name, Employee #, Company,
Sheet 2 has
A
Name
Bookmarks