I have an excel workbook that I use to keep track of all my grades.
Each sheet works like this:
I put the name of the assignment (Col. A) then the points I got (Col. B), then the points it's worth (Col. C), and finally the percent I got (Col. D). At the bottom I have the total points I got in the course, then total number possible in the course, and my percent next to it.
I thought it would be neat to add a VLOOKUP function. So I would know what my current grade was. Instead of just my current percentage then looking up what that corresponded to.
I gave it a try with one of my sheets. Whenever I do the VLOOKUP function all I get is an F instead of what the grade should be.
Here is my function
Code:
=VLOOKUP(D25,A28:C38,3,TRUE)
D25 holds my percent for the class. A25:C38 holds the low percent for a grade, the high percent for a grade, and the letter grade it is worth.
I do not know what I am doing wrong. I even tried changing the percent to what the points would be and then taking my total points in the class. That also did not work.
Any ideas?
Thanks