Need help with VLOOKUP

Copper Contributor

Hello Everyone, I am trying to create a rubric for my semester exams. I keep getting an error in the calculation column. Could someone please help me figure out what is wrong? I am selecting the 'Credit Type' for each student from a dropdown menu in columns B-U. I created a lookup table in columns W-Y. I used the same dropdown menu. Each task has a different credit value, this is the reason for the lookup table. I would appreciate any advice or help. I need to get these exams graded by Thursday. 




1 Reply


VLOOKUP can't handle multiple criteria in multiple columns. Try INDEX and MATCH.





In case you want to sum up the credits, try SUMIFS.