Hi kinalas:
If I have understood you correctly, the following simulation should be of interest to you ...
******** ******************** ************************************************************************>
Microsoft Excel  Book2  ___Running: xl97 : OS = Windows 98 

(F)ile (E)dit (V)iew (I)nsert (O)ptions (T)ools (D)ata (W)indow (H)elp (A)bout  


 A  B  C  D  E  F  G 
1  name  scorequiz1  equivalent  scorequiz2  equivalent  *  9.1 
2  ccc  5  70  30  80  *  100 
3  bbb  9  90  55  98  *  * 
4  aaa  10  100  50  100  *  * 

[HtmlMaker 2.20] To see the formula in the cells just click on the cells hyperlink or click the Name box
PLEASE DO NOT QUOTE THIS TABLE IMAGE ON SAME PAGE! OTHEWISE, ERROR OF JavaScript OCCUR.
if cell G1 houses 9.1, then the formula in cell G2 is ...
=INDEX(C1:C4,IF(INDEX(B1:B4,MATCH(G1,B1:B4))
Does it help?