# lookup table HELP

#### blondiechick

##### Board Regular
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
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.

#### xcellnoob

##### Board Regular
What do you want to do with it?

#### blondiechick

##### Board Regular
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
Hi

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

#### Richard Schollar

##### MrExcel MVP
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
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
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

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

Replies
2
Views
41
Replies
8
Views
319
Replies
5
Views
420
Replies
2
Views
133
Replies
6
Views
112

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.

### Which adblocker are you using?

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

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