student needing help w/vlookup function grading criteria

[Guest]

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

 

[Biff]

Post the EXACT grading criteria table that you have setup.

Biff

 

[Guest]

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