Forum Discussion
Compare Students Grade
How to compare this 2019-20 (table 1) 2020-21 (table 2) A B If 2nd table less than 1st then weak if 2nd table greater than 1st then very good if 2nd table equal to 1st tabl...
Hi there
You may try the following steps.
1) Create a Table listing all the possible students' Grades and assign them a value
2) Give the table a Named Range eg. "GradesTable"
3) You may use any of the two formulas for the Comparison column
Comparison1 =IF(VLOOKUP(B2,GradesTable,2,0)=VLOOKUP(C2,GradesTable,2,0),"Expected",IF(VLOOKUP(B2,GradesTable,2,0)<VLOOKUP(C2,GradesTable,2,0),"Above Expected","Below Expected"))
Comparison2
=CHOOSE(SIGN(VLOOKUP(C2,GradesTable,2,0)-VLOOKUP(B2,GradesTable,2,0))+2,"Below Expected","Expected","Above Expected")
I hope this helps you and gives a solution to your problem
Do let me know if you need more help
Regards
Jeovany