lookup table HELP

[blondiechick]

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.

 

[xcellnoob]

What do you want to do with it?

 

[blondiechick]

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]

Hi

This looks like homework to me, but anyway - is this what you want:

Book1
	A	B	C	D
1	1	Points	Grade
2	2	0	F
3	3	60	D
4	4	70	C
5	5	80	B
6	6	90	A
7
8
9	Name	Ponts	Grade
10	Bob	50	F
11	Henry	65	D
12	Sam	70	C
13	Jenny	85	B
14	Susan	66	D
15	Richard	99	A
Sheet1

 

[blondiechick]

I don't think so. I am new to this, and it is a homework assignment.

I have screen shots.

This is where I have to make up a lookup table for the range A2:B6
http://img99.imageshack.us/my.php?image=pointszn2.jpg

This is the one where I have to enter a formula that I made the lookup table in the other photo. http://img121.imageshack.us/my.php?image=gradehz0.jpg

Thanks again

 

[Richard Schollar]

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]

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]

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?