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")

Data sheet:

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.

Best Answer


  • Alyssa
    Alyssa ✭✭

    Thanks for your help! I was having a difficult time until I realized that the formula won't read embedded hyperlinks... :)

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!