Good day!
I want to ask for help with the formula on INDEX.
This is my main sheet, named Gradebook.
Located on my TG Column on Grade:
=INDEX(Grade!$C$6:$C$30,MATCH(AH11,Grade!$B$6:$B$30,1))
Capture.JPGCapture.JPG
However, this formula can't show the matching grade needed. Regardless of the value, it only shows 3.0.
Here is my sheet for Grade:
Capture1.JPG
Please help me, I'm puzzled on this. Thank you!
Bookmarks