student needing help w/vlookup function grading criteria

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

Post the EXACT grading criteria table that you have setup.

Biff

"Julie" <Julie@discussions.microsoft.com> wrote in message
news:C77A3098-70B8-409B-ADC2-3302DB5C9B66@microsoft.com...
> 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

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" <Julie@discussions.microsoft.com> wrote in message
> news:C77A3098-70B8-409B-ADC2-3302DB5C9B66@microsoft.com...
> > 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
>
>
>