Vlookup HELP
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.
--
Amy
"Toppers" wrote:
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
"netbaby007" wrote:
A1 contains the student name
--
Amy
"Toppers" wrote:
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
|