Hi Jared,

For the A test try this in D12 on the Math sheet...

=INDEX('Math A'!$D$5:$AC$56,$C7*2+1,$C2+1)
which returned 556

and this in E12...

=INDEX('Math A'!$D$5:$AC$56,$C7*2+2,$C2+1)

which returned 8.2


Similarly for the other levels...

Level D...

=INDEX('Math D'!$D$5:$AC$56,$C8*2+1,$C3+1)
in D13 on the Math sheet, and...

=INDEX('Math D'!$D$5:$AC$56,$C8*2+2,$C3+1)
in E13 on the Math Sheet, etc for the remaining two levels M and E.


Ken Johnson