Hi Le,
I guess it would have been better to have swapped the 5th and 6th
column positions so that test1 is to the left of test 2 for both name
lists.

Then column 3's formula is:
=VLOOKUP(A2,$D$2:$F$6,3,FALSE) filled down 3 rows

and column 5's formula is:
=VLOOKUP(D2,$A$2:$B$4,2,FALSE) filled down 5 rows

I hope you find this useful

Ken Johnson