Afternoon,
I have used this formula:
=INDEX(LOOKUP!$B$15:$B$31,MATCH('KS5 EOCP'!N2,LOOKUP!$A$15:$A$31,0))
To lookup school grades such as (A+, A, A-, and so on) and turned it into a number. I have two sheets with these grades in, so on a third sheet I would like to work out how many sublevels the difference is. So by giving each of the values a number I should be able to take one away from the other to work out the sublevels. So I have tried to use the formula:
=INDEX(LOOKUP!$B$15:$B$31,MATCH('KS5 EOCP'!N2,LOOKUP!$A$15:$A$31,0)-(INDEX(LOOKUP!$B$15:$B$31,MATCH('KS5 ALPs'!N2,LOOKUP!$A$15:$A$31,0))))
But it keeps coming up with #value errors.
Any help would be gratefully appreciated.
Thanks
Bookmarks