Microsoft Excel question - finding the intersection of two lists

PremiumG

Platinum Member
Jun 4, 2001
2,030
0
76
Excel experts, I have a 2 lists of names separated into four columns.

First name, last name and the first name, last name.

How can I make a list of names that both sets have in common? (the intersection of the two sets)? I heard this is possible without database programs and in Excel.
 

PremiumG

Platinum Member
Jun 4, 2001
2,030
0
76
or even if excel does not work, what freeware programs out there can I use?
 

akenbennu

Senior member
Jul 24, 2005
747
322
136
I'm not sure how well it will work, but you might want to use the concatenate function to merge the two sets of names into two columns, then use one of the lookup functions to run a comparison (I think VLOOKUP will work for this, but it's been a while since I used it.)