I am trying to assign a student a grade (A, B, C etc.) dependent upon the score they get in an exam.
However there are two types of exam that the students could have done (Higher and Foundation) and the grade boundaries are different for each test.
I want the formula to recognise which test they have done by looking at what I have entered in a particular column (either H or F) and then assign a value accordingly...
Here is the formula I had hoped would work:
=IF(O3="H",[LOOKUP(P3,{42,38,33,29,26,24,0},{"*","A","B","C","D","E","F","G","U"})],[LOOKUP(P3,{36,32,28,25,22,0},{"C","D","E","F","G","U"})])
but Excel returns 'the name that you entered is not valid' and then highlights LOOKUP.
Any ideas?
Bookmarks