lookup table HELP

blondiechick

Board Regular
Joined
Oct 13, 2006
Messages
60
I have these two problems i am stuck on. They both deal with lookup tables. I have a set of data on one page this includes the points and the grades. I am supposed to make a lookup table out of that.

the information for that is

A_________B
1_________Points_____Grade
2___________0_______F
3___________60______D
4___________70______C
5___________80______B
6___________90______A

I have a link for it http://info.cba.ksu.edu/bkovar/projectexcel2.htm

It's case number 1 and I need help on #4-5. I also need help on #8-9. So if anyone could help that would be great. Its so confusing.

 

Excel Facts

What is the last column in Excel?
Excel columns run from A to Z, AA to AZ, AAA to XFD. The last column is XFD.

blondiechick

Board Regular
Joined
Oct 13, 2006
Messages
60
First. I want the range A2:B6 and create a lookup table for the range of grades that are listed above. Now lets say this is worksheet A

Then. On worksheet B i want to insert a formula to calculate the final letter grade for each student based on the table in worksheet A.
 

Richard Schollar

MrExcel MVP
Joined
Apr 19, 2005
Messages
23,707
Hi

This looks like homework to me, but anyway - is this what you want:
Book1
ABCD
11PointsGrade
220F
3360D
4470C
5580B
6690A
7
8
9NamePontsGrade
10Bob50F
11Henry65D
12Sam70C
13Jenny85B
14Susan66D
15Richard99A
Sheet1
 

blondiechick

Board Regular
Joined
Oct 13, 2006
Messages
60

Richard Schollar

MrExcel MVP
Joined
Apr 19, 2005
Messages
23,707
I'm pretty sure what I've already given does what you want:

=VLOOKUP(E2,Points!$A$2:$B$6,2)

is the formula you would enter into F2 of sheet Section 1.

Is this not what you wanted?

Richard
 

blondiechick

Board Regular
Joined
Oct 13, 2006
Messages
60
it says #NAME? when I type it in F2.

I think I just need to create a lookup table for the points worksheet now. The F2 formula is right.

I need to create it for the ranges A2:B6. A1 would be points and B1 would be grade. I read the help files on excel and searched the web for lookup tables, but they didn't have any that fitted this problem.

Thanks
 

blondiechick

Board Regular
Joined
Oct 13, 2006
Messages
60
I got it! You were right. Thanks so much!

I have one more question

The last question says clear all data values from the worksheets.

A= Student ID
B= Exam 1
C= Exam 2
D= Final
E = Points
F = Grade

Do I clear the student ID, is that a data value? or do I just clear the points and the grade?
 

Forum statistics

Threads
1,136,649
Messages
5,676,990
Members
419,667
Latest member
MegEri

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top