I am doing admin for a college department. I want to enter the student's grades in A1:A10, for example, and in one cell, to convert those grades to grade points...an A becomes 4.0; a B+ becomes 3.3, etc.
I tried doing a vlookup for multiple lookup values. If I do =vlookup({"A","B+","C"},<lookup array>,2,0), it will work (but each element does a dynamic array and spills into the next column...can i turn that off?). Ah, I digress...
However, I don't want to list the individual grades in an array in the vlookup function, I want to use the cell references, A1:A10. Also, I want to use sumproduct to multiply each grade point by the number of units for that course.
Any ideas? Thank you in advance!
I tried doing a vlookup for multiple lookup values. If I do =vlookup({"A","B+","C"},<lookup array>,2,0), it will work (but each element does a dynamic array and spills into the next column...can i turn that off?). Ah, I digress...
However, I don't want to list the individual grades in an array in the vlookup function, I want to use the cell references, A1:A10. Also, I want to use sumproduct to multiply each grade point by the number of units for that course.
Any ideas? Thank you in advance!