Hello.
I have a grade tracking sheet but the lookup is not working properly.
There are two sets of grades, and then a column is needed to "track" the difference.

Column A - Current Grade (alpha)
Column B - Expected Grade (alpha)
Column C - "On Track" (numeric e.g Current C, Expected A on track would read -2)

Rows are allocated to a student each.
Grades - A*, A, B, C, D, E, F, U (Highest first)

I am happy for there to be a separate lookup elsewhere on the sheet.

Thank you in advance!!