It is not clear (to me) what exactly you are trying to do.

In the example below, XX is a scale value, then it will return the
corresponding grade value if it finds a scale match in column J.

=VLOOKUP(XX,J20:K24,2,False)

If A1 (for example) contains a scale value then use

=VLOOKUP(A1,J20:K24,2,False)


HTH


"netbaby007" wrote:

I know there is someone out there to help me with this. Unfortunatley, I have
waited until the last minute, trying to figure this out on my own!

I have a worksheet assignment asking to use the vlookup on Semester grade
and using the grading criteria. Gosh, my instructor won't even email me back!
=VLOOKUP(J4,K20,K4,TRUE)
I just don't get this.......grading criteriais in j20-24=scale and
k20-24=grade, and I'm using the semester average in k4, grade goes in L4 and
there are 14 students.

Anyone have an idea?
Thanks!

--
Amy