Forum Discussion
Need help with VLOOKUP
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 'Cre...
VLOOKUP can't handle multiple criteria in multiple columns. Try INDEX and MATCH.
https://exceljet.net/formulas/index-and-match-with-multiple-criteria
=INDEX($Y$2:$Y$61,MATCH(1,($W$2:$W$61=$B$1)*($X$2:$X$61=B2),0))
In case you want to sum up the credits, try SUMIFS.
https://exceljet.net/functions/sumifs-function
=SUMIFS($Y$2:$Y$61,$W$2:$W$61,$B$1,$X$2:$X$61,B2)