Excel macro for comparing data

Hello,

Here is my problem. See below for example.

(Workbook A)
First name Last name Score
A1 = John B1 = Doe C1 = 4
A2 = Mark B2 = Jones C2 = 3
A3 = John B3 = Bates C3 = 1
(Workbook B)
A1 = John B1 = Bates C1 = blank
A2 = John B2 = Doe C2 = blank

Question: What is the excel macro code/vba code if I want to compare Workbook B to Workbook A? Say, Workbook B A1 matches with Workbook A A1 and A3, then from the result we will then compare Workbook B B1 to Workbook A B1 and B3, it is obvious that the correct match is row 3 of Workbook A. By that, I need to copy Workbook A C3 data and paste it to Workbook B C1 cell. Same goes to Workbook B C2 which I need to paste the data from Workbook A C1.


Thanks in advance