Problems with Lookup

[Cmorgan]

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

[ben_hensel]

Looks like you're nesting the second INDEX inside the first one so you're borking up the order of operations.

Try this:

Please Login or Register  to view this content.