Set your Grade Table up as follows
0 F
50% D
65% C
70% B
85% A
Do Insert Name Define, and name this range GRADES
Then, assuming your GradePercentage is in A1, use this formula to look up
the grade
=VLOOKUP(A1,GRADES,2,TRUE)
Vaya con Dios,
Chuck, CABGx3
"Neoseraph" wrote in message
...
Hi, I need help to setup the VLOOKUP function for an assignment. Everytime
I
try to do it, it says, #NA.
I need to use VLOOKUP to put in the letter grade for a list of students's
grades in % on their midterms.
The average % is in cells D8:D18.
The lookup table I made (in cells I9:J13) is as followed:
85% and above A
70% and above B
65% and above C
50% and above D
Below 50% F
This is what I tried for VLOOKUP but got #N/A:
lookup value: D8
table array: I9;J13
col_index_num: 2
so the final formula looks like this: =VLOOKUP(D8,I9:J13,2)
and that gave me #N/A.
Can anybody help please???
|