Microsoft Office Forums

Go Back   Microsoft Office Forums > Microsoft Excel > Excel

Reply
 
LinkBack Thread Tools Display Modes
  #1  
Old 04-15-2010, 11:56 AM
Sailorcancer Sailorcancer is offline Windows 7 Office 2010 (Version 14.0)
Novice
 
Join Date: Apr 2010
Posts: 2
Sailorcancer is on a distinguished road
Default 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
Reply With Quote
  #2  
Old 04-15-2010, 12:22 PM
ConneXionLost's Avatar
ConneXionLost ConneXionLost is offline Windows XP Office 2003
Simulacrum
 
Join Date: Jan 2010
Location: Victoria, Canada
Posts: 86
ConneXionLost is on a distinguished road
Default

There's nothing wrong with the function.

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

Cheers,
Reply With Quote
  #3  
Old 04-15-2010, 01:16 PM
Sailorcancer Sailorcancer is offline Windows 7 Office 2010 (Version 14.0)
Novice
 
Join Date: Apr 2010
Posts: 2
Sailorcancer is on a distinguished road
Default

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!
Reply With Quote
  #4  
Old 04-15-2010, 09:55 PM
Chaitanya_Sagar Chaitanya_Sagar is offline Windows Vista Office 2007
Novice
 
Join Date: Nov 2009
Posts: 6
Chaitanya_Sagar is on a distinguished road
Default

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

Chaitanya

Reply With Quote
Reply

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


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


Powered by vBulletin® Version 3.8.1
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.
MSOfficeForums.com is not affiliated with Microsoft