Lookup table

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Rhonda - 17 Sep 2007 20:42 GMT

How to I create a lookup table (in the worksheet) and use the =lookup
function for a letter grade based on the quiz average with these rules:

An average below 60, the grade is a F.
An average of 60 or more but below 65, the grade is a D.
An average of 65 or more but below 70, the grade is a D+
An average of 70 or more but below 75, the grade is a C.

Thanks in advance!

Rhonda

Reply to this Message

JE McGimpsey - 17 Sep 2007 23:51 GMT

> How to I create a lookup table (in the worksheet) and use the =lookup
> function for a letter grade based on the quiz average with these rules:
[quoted text clipped - 3 lines]
> An average of 65 or more but below 70, the grade is a D+
> An average of 70 or more but below 75, the grade is a C.

One way:

J K
1 Score Grade
2 0 F
3 60 D
4 65 D+
5 70 C
6 75 etc

If the quiz average is in A1:

=VLOOKUP(A1,$J:$K,2,TRUE)

Reply to this Message

Rhonda - 19 Sep 2007 21:20 GMT

Thank you JE but unfortunately I did not have enough info from you to make
this work. I posted another with add'l information that might help someone
help me, smile. Thanks anyway!

> > How to I create a lookup table (in the worksheet) and use the =lookup
> > function for a letter grade based on the quiz average with these rules:
[quoted text clipped - 17 lines]
>
> =VLOOKUP(A1,$J:$K,2,TRUE)

Reply to this Message

Mac Forum / Applications / Excel / September 2007

Lookup table