Data Matching Names from One Spreadsheet to Another

[bobothesmart]

I am trying to do a data matching activity and I'm having difficulty figuring out how to do it.

I have two spreadsheets. Sheet1 has the columns LastName, FirstName, Birthdate, and Score. Sheet2 also has LastName, FirstName, Birthdate, and Score, but the Score is blank. There are a lot of names in Sheet1 and fewer in Sheet2.
I want to compare the names and birthdates. Any time the full name and birthdate in Sheet1 is found to match a full name and birthdate in Sheet2, it will copy the Score from Sheet1 to Sheet2. There will be many times that there will be no match and in those cases it will leave the Score blank.

Any help?

 

[Scott T]

Try

	A	B	C	D
Lname	Fname	bdate	score
lname1	fnmae1
lname2	fnmae2
lname3	fnmae3
lname4	fnmae4
lname5	fnmae5
lname6	fnmae6
lname7	fnmae7
lname8	fnmae8
lname9	fnmae9
lname10	fnmae10
lname11	fnmae11

<TBODY>
[TD="align: center"]1
[/TD]

[TD="align: center"]2
[/TD]

[TD="align: right"]1/1/1970
[/TD]
[TD="align: right"]55
[/TD]

[TD="align: center"]3
[/TD]

[TD="align: right"]2/7/1980
[/TD]
[TD="align: right"]66
[/TD]

[TD="align: center"]4
[/TD]

[TD="align: right"]3/18/1966
[/TD]
[TD="align: right"]44
[/TD]

[TD="align: center"]5
[/TD]

[TD="align: right"]3/18/1977
[/TD]
[TD="align: right"]96
[/TD]

[TD="align: center"]6
[/TD]

[TD="align: right"]4/18/1977
[/TD]
[TD="align: right"]33
[/TD]

[TD="align: center"]7
[/TD]

[TD="align: right"]7/20/1990
[/TD]
[TD="align: right"]50
[/TD]

[TD="align: center"]8
[/TD]

[TD="align: right"]7/20/1990
[/TD]
[TD="align: right"]99
[/TD]

[TD="align: center"]9
[/TD]

[TD="align: right"]7/27/1997
[/TD]
[TD="align: right"]22
[/TD]

[TD="align: center"]10
[/TD]

[TD="align: right"]7/20/1999
[/TD]
[TD="align: right"]90
[/TD]

[TD="align: center"]11
[/TD]

[TD="align: right"]7/20/1991
[/TD]
[TD="align: right"]70
[/TD]

[TD="align: center"]12
[/TD]

[TD="align: right"]7/20/1990
[/TD]
[TD="align: right"]60
[/TD]

</TBODY>

Sheet1

Book1
	A	B	C	D
1	Lname	Fname	bdate	score
2	lname1	fnmae1	1/1/1970	55
3	lname2	fnmae2	2/7/1980	66
4	lname3	fnmae3	3/18/1966	44
5	lname4	fnmae4	3/18/1977	96
6	lname5	fnmae5	4/18/1977	33
7	lnotin1	Fnotin1	8/7/1980
8	lname7	fnmae7	7/20/1990	99
9	lname8	fnmae8	7/27/1997	22
10	lname9	fnmae9	7/20/1999	90
11	lname10	fnmae10	7/20/1991	70
12	lname11	fnmae11	7/20/1990	60
Sheet2

Cell Formulas
Range	Formula
D2	{=IFNA(INDEX(Sheet1!$D$2:$D$12,MATCH(Sheet2!A2&Sheet2!B2&Sheet2!C2,Sheet1!$A$2:$A$12&Sheet1!$B$2:$B$12&Sheet1!$C$2:$C$12,0)),"")}
Press CTRL+SHIFT+ENTER to enter array formulas.

​

 

[Fluff]

Hi & welcome to MrExcel.
Assuming you are looking at columns A, B, C with score in D. How about
=IFERROR(INDEX(Sheet1!$D$2:$D$25,MATCH(A2&"|"&B2&"|"&C2,INDEX(Sheet1!$A$2:$A$25&"|"&Sheet1!$B$2:$B$25&"|"&Sheet1!$C$2:$C$25,0),0)),"")

 

[bobothesmart]

Thank you both so much for the quick reply! I ended up using the IFERROR method and it worked perfectly!

 

[Fluff]

Glad we could help & thanks for the feedback