match data
name test1 test2 name test2 test1
tina 86 85 mark 75 80
mark 80 75 tina 85 86
jim 45 #N/A jane 86 #N/A
jake 51 #N/A
mary 95 #N/A
I used vlookup in 3rd column
=VLOOKUP(A2,$D$2:$E$6,2,FALSE) filled down three rows
and again in 6th column
=VLOOKUP(D2,$A$2:$B$4,2,FALSE) filled down 5 rows
after inserting these columns for showing both test scores for both
name lists.
Sorry if they haven't lined up very well.
Ken Johnson
|