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

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