Ok, here's what I did for the Range_lookup part:

I put in 0.00 and it give me false instead of true if I put 0.85, but then
that gave me #NA again. So what's wrong?

"Neoseraph" wrote:

How do I setup the True or False as range lookup?


"Bruno Vermeersch" wrote:

You omitted True or False as Range_Lookup.
This means that True is assumed.
So : your values must be in ascending order.

Try this in the cells I9:J13
0% F
50% D
65% C
70% B
85% A

It should be working now,
Bruno


"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???