Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Vlookup HELP
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Vlookup HELP
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Vlookup HELP
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 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Vlookup HELP
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 |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
VLookup a Vlookup | Excel Worksheet Functions | |||
VLOOKUP Problem | Excel Discussion (Misc queries) | |||
VLOOKUP Limitations | Excel Worksheet Functions | |||
Have Vlookup return a Value of 0 instead of #N/A | Excel Worksheet Functions | |||
vlookup data hidden within worksheet | Excel Worksheet Functions |