Vlookup HELP

[Guest]

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!

 

[Guest]

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

 

[Guest]

A1 contains the student name
--
Amy

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

 

[Guest]

Sorry ... still not clear: are you trying to lookup a grade based on a
student's scale (or vice versa)?

J20:J24 contains a scale
K20:K24 contains a (corresponding) grade

What is in J4?
And K4 is semestar average grade?

If J4 is a scale then:

=VLOOKUP(J4,J20:K24,2,False) returns the Grade corresponding to the scale
in J4 which matched with the scale values in J20:J24.

The 2 in the VLOOKUP formula means return the data from the second column of
your lookup table which is (in this case) contained in colums J and K, rows
20 to 24.

HTH

 

[Guest]

I am trying to assign a grade based on the semester average. J4 really
doesn't need to be there I guess. It contains "bonus/penalty" for homework
witch is either 2 or -2.

Yes k4 is the semester average. Thank you so much for helping.