Assume your raw score is in A1, with test type in B1. Then you could
have something like this in C1 to select the appropriate table:

=VLOOKUP(A1,INDIRECT("table "&B1),2)

This assumes your tables would be like this:

0 E
25 D
40 C
55 B
70 A

or something similar, where a score of 25 to 39 would merit a D, for
example.

Hope this helps.

Pete


On Oct 11, 11:43 pm, confused teacher <confused
wrote:
My skills are limited.....

I am, creating a spreadsheet for a group of children. They can complete 1
of 3 tests according to ability and I want to create a function where if test
type is selected (a,b,or c) then a corresponding lookup table can be selected
to convert a raw score to a grade.

e.g. test a refers to lookup table a, test b to table b etc....

help!!