Matching two employee directories, and adding the Employee #

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