Align/match columns with nearly same text

[Benefits Recon]

Hi all,

I've found this forum after hours of google searching/researching. I've seen some fantastic examples that I've tried to amend to work for my situation, but am failing miserably.

Here's my issue:
Sheet 1: "monthly insurance invoice", column a- names (last first) & column b- premium amount charged
Sheet 2: "diffed internal report", column a- names (last first sometimes middle initial at end) & column b- premium amount deducted
Sheet1 usually contains more names than sheet 2. The amounts must travel with the names, but I need one final sheet that has each name matched up and combined when matched, and blank spaces where data is missing from the opposing sheet. I'm working with about a thousand rows on each sheet.

Unfortunately, the restrictions on the machines where I work won't allow me to download the html uploader, so I'm not sure how best to illustrate what I'm needing. Any suggestions?

If there is a better way of displaying the final result, or even trimming off the middle initials at the end of the name cells- I'd be happy to try that as well!

Any help would be so very appreciated.

Thanks again!


​

 

[Benefits Recon]

Shameless bump... any thought or suggestions? Thanks so much for the input!ray:

 

[Benefits Recon]

I've now realized that I have a SSN column on each report. Is there a way to match the numbers in those columns so that the other data associated will trail along?