Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
vlookup
Hi there, I am creating a scoring model to determine a letter grade based upon a raw score. I have a list of inputs (ie assignments, tests) with different weights, and i've created a forumla that calculates out the raw score. Is there a way that I can create a vlookup formula/table to determine a corresponding letter grade, without having to put 1%, 2%, 3%, .....100 down a column? I'd like to have something like For example, _A_ _B_ 0-50 F 51-53 D- 54-57 D 57-60 D+ 61-63 C- |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
vlookup
I did this for somebody a while back, and haven't heard anything, so I guess
it works :) It assumes the lookup value in A2 and the lookup table on a separate sheet named "lookup table": =VLOOKUP(A2,'lookup table'!$A$1:$B$12,2) 0 F 51 D- 54 D 57 D+ 61 C- hth, Doug " wrote in message ... Hi there, I am creating a scoring model to determine a letter grade based upon a raw score. I have a list of inputs (ie assignments, tests) with different weights, and i've created a forumla that calculates out the raw score. Is there a way that I can create a vlookup formula/table to determine a corresponding letter grade, without having to put 1%, 2%, 3%, .....100 down a column? I'd like to have something like For example, _A_ _B_ 0-50 F 51-53 D- 54-57 D 57-60 D+ 61-63 C- |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
vlookup
I column A enter 0, 51, 54, 57, 61 on up to whatever. With the associated
grade in column B. =VLOOKUP(E1,A1:B5,2,1) Where E1 = the score. HTH Regards, Howard "inoexcel" wrote in message ... Hi there, I am creating a scoring model to determine a letter grade based upon a raw score. I have a list of inputs (ie assignments, tests) with different weights, and i've created a forumla that calculates out the raw score. Is there a way that I can create a vlookup formula/table to determine a corresponding letter grade, without having to put 1%, 2%, 3%, .....100 down a column? I'd like to have something like For example, _A_ _B_ 0-50 F 51-53 D- 54-57 D 57-60 D+ 61-63 C- |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
vlookup
Thanks guys, both methods worked! -- inoexcel ------------------------------------------------------------------------ inoexcel's Profile: http://www.excelforum.com/member.php...o&userid=33055 View this thread: http://www.excelforum.com/showthread...hreadid=531664 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
VLOOKUP Problem | Excel Discussion (Misc queries) | |||
Using single cell reference as table array argument in Vlookup | Excel Worksheet Functions | |||
VLOOKUP Limitations | Excel Worksheet Functions | |||
Have Vlookup return a Value of 0 instead of #N/A | Excel Worksheet Functions | |||
vlookup data hidden within worksheet | Excel Worksheet Functions |