Help with an Excel Question

[goobee]

Let's say I have two lists,

List A

First Name, Middle Name, Last Name, DOB, etc.

List B

First Name, Middle Name, Last Name, DOB, etc.

Each list can have several thousand rows. What I need to do is compare for matches with Last Name and DOB. If Last Name and DOB matchs, then both row items are copied to the same row on a third sheet. If either list is missing the DOB but the last names match, both row items are copied to the same row on a third sheet.

Anyone want to take a crack at this? I'm guessing a VBA macro will be the best way to tackle this. Thanks.

 

[NeoV]

yes, VBA would do the trick, but with a little bit of manual work, you could do this as well.

Are you familiar with concatenate and vlookup?

 

[goobee]

I am familiar but would like to use a macro since this will be a frequent tasks.