I have to two worksheets with nearly the same information. One sheet has names and id numbers. The other work sheet has names and only the last four of their id number and LOTS of other information I need. How do I combine the worksheets together matching the last names/full ID's into the worksheet with the last names and last four overwriting the last four with their full ID's.

Regards.