Sorry if this has been posted but I've been having a hard time finding what I'm looking for. It's much easier to explain my dilemma. I am currently trying to evaluate team strength of schedule. So I have each game listed out week by week like so:

Away Home
Team A Team B
Team C Team D
... ...
Team A Team E

I also have a master sheet based on statistics I've entered and gave each team a 'score.' I want to take a team from the Away column, say "Team A", have it choose multiple Home teams in the same row, in this case "Team B" and "Team E" and sum the scores I've given to each team in the master sheet. I am assuming there is a way with some kind of mixture of sumif, vlookup, or match but I cannot logically think at this hour. Thanks in advance!

-rouski