the first time I did it I only put the E2 in there. I will try changing the
formula again.
--
Too old to be in college


"Tom Hutchins" wrote:

I think you need to make two changes to your formula:
1. Only refer to a single cell in column E (for example, E2). When you copy
the formula down the column for the other cells, the reference will change
automatically.
2. Your reference to the range on the Grading Criteria sheet needs to be
made absolute, so it WON'T change as you copy the formula down. To make a
column or row address absolute, put a $ in front of it.

So, your revised formula would look like this for row 2:

=VLOOKUP(E2,'Grading Criteria'!$A$2:$B$6,2)

and copy it down through row 16. Hope this helps,

Hutch

"Kimmer" wrote:

I am trying to do my homework again. I have done everything I can to get
this to work and I keep getting error messages.

I am trying to get the letter grade on 3 worksheets. I have a forth
worksheet that has the criteria for the letter grades. I have a list of
grade scores and I need to get the letter on it. I have put in this formula
and it shows the first letter grade but shows errors in the rest.
VLOOKUP(E2:E16,'Grading Criteria'!A2:B6,2) I am not sure what I am doing
wrong. I copy try to highlight down the column and then get like 2 more of
the 16 students grades as B the rest show an error #NA. What am I doing
wrong?
Cell A2 Cell B2 A6 B6
-- 0 F 90 A
A3 B3
50 D
A4 B4
60 C
A5 B5
75 B
Too old to be in college