i thought had the right formula however the formula i have used in the pic only shows numbers as i didnt count for if a game gets postponed, if a game gets postponed it shows a 'p' instead of a number which messes up the formula.
The formula needs to try and find the team name from column 'c'...