Formula to lookup a value based on criteria in 2 different columns?
I am looking for some help with a formula on my Roll-up sheet. I want to pull the Score by Site for the different years based on the information populated in my Data Sheet.
Criteria #1: Site Name (e.g. Chandler, Chicago)
Criteria #2: Year (e.g. "2018", "2019", "2020")
Roll-up sheet example (where I'll plug in the formulas to be able to look up the Site's 2018 score, 2019 score, etc.
I completed the Weighted score with a =vlookup, but I am having trouble factoring in the 2 criteria for a lookup formula.
Help Article Resources
Check out the Formula Handbook template!