Microsoft Office Forums VLOOKUP in Excel with grade book.
 User Name Remember Me? Password
 Register FAQ Search Today's Posts Mark Forums Read

#1
04-15-2010, 11:56 AM
 Sailorcancer Windows 7 Office 2010 (Version 14.0) Novice Join Date: Apr 2010 Posts: 2
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)`
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
#2
04-15-2010, 12:22 PM
 ConneXionLost Windows XP Office 2003 Simulacrum Join Date: Jan 2010 Location: Victoria, Canada Posts: 86

There's nothing wrong with the function.

Convert cells D25 and A28:A38 to decimal format and make sure they're comparable.

Cheers,
#3
04-15-2010, 01:16 PM
 Sailorcancer Windows 7 Office 2010 (Version 14.0) Novice Join Date: Apr 2010 Posts: 2

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
04-15-2010, 09:55 PM
 Chaitanya_Sagar Windows Vista Office 2007 Novice Join Date: Nov 2009 Posts: 6

If you have fixed it on our own, you have learnt it! Congrats!

Chaitanya

 Thread Tools Display Modes Linear Mode

 Similar Threads Thread Thread Starter Forum Replies Last Post thelauncher Excel 5 08-25-2013 11:32 PM Delson Excel 4 02-08-2010 01:27 PM kbnotes Excel 0 01-19-2010 07:46 AM Tony G Excel 9 03-28-2009 11:16 PM bunnygum Excel 1 03-24-2009 05:10 AM

All times are GMT -7. The time now is 10:08 PM.

 -- Default Style -- Mobile Style Contact Us - Privacy Statement - Top