Hi lcartwright.
Thanks for getting in touch. It would seem first though I need to average out these three cells to find an average of how each child is doing in maths.
How can I adapt this:
=IFERROR(INDEX(Sheet2!$A$1:$A$9,
MATCH(ROUND(AVERAGE(INDEX(Sheet2!$B$1:$B$9,MATCH(Maths!F38,Sheet2!$A$1:$A$9,0)),
INDEX(Sheet2!$B$1:$B$9,MATCH(Maths!G38,Sheet2!$A$1:$A$9,0)),
INDEX(Sheet2!$B$1:$B$9,MATCH(Maths!H38,Sheet2!$A$1:$A$9,0)),
INDEX(Sheet2!$B$1:$B$9,MATCH(Maths!I38,Sheet2!$A$1:$A$9,0)),
INDEX(Sheet2!$B$1:$B$9,MATCH(Maths!J38,Sheet2!$A$1:$A$9,0))),0),Sheet2!$B$1:$B$9,0)),"")

so that it averages columns J, K & L? Surely I only need to adapt a couple of letters?

Any ideas?