Look up tables, I am going to try for help again!!!!

[AmyAnn]

Lookup tables!! Please!!! 43 views and NO help!!!!
I have an assignment that I have been trying to figure out and hope that someone may be able to help me with it. In the instructions it tells me in the range A2:B6, create a lookup table for the range of grades specified.
0 to 49=F
50-59=D
60-74=C
75-89=B
90-100=A

Each grade should be matched up with the lowest score possible.
If someone can please help me.

Thanks for taking the time!!!

 

[Smitty]

Welcome to the Board!

Something like this:

Book4
	A	B	C	D
1	Number Grade	Letter Grade	Lookup	Grade
2	0	F	100	A
3	50	D
4	60	C
5	75	B
6	90	A
Sheet1

Hope that helps,

Smitty

 

[AmyAnn]

But how to I get there. I just dont understand the VLOOKUP at all. I go to insert and then function, VLOOKUP and then a box comes up. Where do I go from there?

 

[Smitty]

The formula in D2 is =LOOKUP(C2,A2:B6)

Just copy it.

The helpfile gives a good explanation of how Lookup & Vlookup work.

Smitty