#1
|
|||
|
|||
VLOOKUP in Excel with grade book.
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) 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 |
#2
|
||||
|
||||
There's nothing wrong with the function.
Convert cells D25 and A28:A38 to decimal format and make sure they're comparable. Cheers, |
#3
|
|||
|
|||
Thanks for the reply but I found out what I was doing wrong.
I had my look up table going from A-F High-Low. Instead of F-A Low-High. Thanks for help! |
#4
|
|||
|
|||
|
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Using Vlookup & IF together | thelauncher | Excel | 5 | 08-25-2013 11:32 PM |
Is this possible using the Vlookup or any other function? | Delson | Excel | 4 | 02-08-2010 01:27 PM |
Looking for technical reviewer for Excel book | kbnotes | Excel | 0 | 01-19-2010 07:46 AM |
vlookup question | Tony G | Excel | 9 | 03-28-2009 11:16 PM |
Vlookup and If statement problem | bunnygum | Excel | 1 | 03-24-2009 05:10 AM |