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-

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-

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-

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