Hi I think this may be a tricky one, so I'd really appreciate any help. On the 'Cohort' tab in G5 I am trying to write a formula that will work out a grade based on what is in columns E2 and C5. I can do it for one specific combination of rules, but am struggling to work out how to make it apply to others. The combinations are as follows:
E2 C5
L F
L H
R F
R H
W F
W H
The L/R/W stand for 'Listening', 'Reading' and 'Writing'. The F and H stand for 'Foundation' and 'Higher'. The idea is that if a student, for example sits a Foundation Writing paper the VLOOKUP would look under the 'Ref' tab in columns W to Y to give out a grade from U to 5. Can this even be done with so many combinations?
Bookmarks