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