Excel

Set up a grid as follows.

Select the column headers and define a named range called "__Test__" to represent the tests.

Select the row headers and define a named range called "__Students__" to represent the students.

Select the grid of stanine results and define a named range called "__Results__" to represent the student scores on the respective tests.

Create a pulldown list of students (reading from the named range).

Do the same for tests.

Now by entering the formula as shown, the cell will display the result of a given test for a given student as per the 2 pull down menus.

Try it with different parameters.