Compare Data in Two Spreadsheets

[jafornwalt]

Hi, I tried to find the answer in other threads, but couldn't find exactly what I need. I have 2 spreadsheets that both have column A as Last Name and Column B as First Name. I need to compare both spreadsheets to find exact matches to both columns. I can do the match formula to match last names, but that gives me too many results. Can you help?

 

[vmjan02]

Try this.

In both the sheets add a column before column A as First & Last name
then add this function in cell A1 (in both the sheets

=TRIM(B2&" "&C2) --- Here column B is First Name and column C is Last Name in sheet1
=TRIM(B2&" "&C2) --- Here column B is First Name and column C is Last Name in sheet2

then in column D -- (Find name from sheet2)
Cell D2
=VLOOKUP(A2,Sheet2!A1:C3,1,0) -- here 1 is First & Last Name (column A)

First & Last Name	Last Name	First Name	Find in sheet2
=TRIM(B2&" "&C2)	V	Sh	=VLOOKUP(A2,Sheet2!A:C,1,0)
=TRIM(B3&" "&C3)	Jon	Karter