That was my problem. The setup grading criteria. Problem fixed. Thanks I
has put in ex:0-49 F 50-59 D, when I had two numbers it didn't work, and
I eliminated and just put highest score for each grade ex: 49 F etc.
Thanks. Julie

"Biff" wrote:

Post the EXACT grading criteria table that you have setup.

Biff

"Julie" wrote in message
...
My look up table is in grading criteria one sheet set up as
Average Exam Grade
0.00 F ets


one the following sheets are list of studnets with three exams each and an
average of all scores cell E2 is the average of all scores. My formula
is:
VLOOKUP(E2,'GRADINGCRITERIA'!$A$2:B6,2,TRUE) i GET A LETTER GRADE BUT ALL
THE STUDENTS MADE AN A. Even the f's. Help please