Sep 20 2022 11:03 AM
Sep 20 2022 12:46 PM
Presumably, though, there are names associated with the grades too...and you want to make sure you're comparing John Doe's grades from the two years....
Is it possible for you, @shahid20 ,to give us the full structure of the two tables? That formula from @Quadruple_Pawn is great for the data you've shared, but I find it hard to believe it's going to be that simple, unless you've already taken care of making sure each row in each table is for the same student.
Oct 16 2022 02:58 AM
Please, find your answer in this link
Oct 16 2022 03:06 AM
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"))
=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