If you get a REF error with that formula you must have either deleted
something linked to A1 or used a non existent reference. Try the formula in
a new workbook and put in a value in A1
--
Regards,
Peo Sjoblom
"Neoseraph" wrote in message
...
Ok, when I tried your method, it gives me #REF! either by entering a
number
in A1 or the cell A1 itself, please help me solve the problem...
"Gord Dibben" wrote:
Another method of grading as you desire.
Enter this formula in B1. You don't need a separate table, the table is
in
the formula.
=LOOKUP(A1,{0,50,65,70,85},{"F","D","C","B","A"})
Enter a number in A1
Gord Dibben Excel MVP
On Sun, 3 Apr 2005 08:15:03 -0700, Neoseraph
wrote:
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???
|