Setting up a grading matrix, vlookup doesn't help

Hi there,
I 'foolishly' offered to help a local school set up some standard forms etc! All have gone OK except for this one which is driving me nuts. I have tried vlookups, if functions etc, just can't get it working... I suspect it needs some VBA...

I have attached what I am trying to achieve. Input tab has the data, basically a set of grades for students, one grade at age 8, the other grade at age 11. I am trying to present this in a matrix, see Output tab. I want to automatically place the student name(s) in the cell that corresponds to their two grades. I have manually done the first 6 names.
teacher grading tool.xlsx

Your assistance would be much appreciated.
Thanks