Fantasy Football (Soccer) League

[Goonerruss]

Hi everyone, I have a very basic understanding of Excel and have seen a few YouTube tutorials on formulas etc. however what I am looking for is some help on this fantasy league I've created, It's a 10 team league based on the 2021/22 Premier League fixtures. I want to be able to input the office fixtures week by week then input the results into the Prem Fixtures, if the correct match prediction has been guessed that person will get 3 points (guessed 2-1 and the match finished 2-1), if the correct match result has been guessed that person will get 1 point (guessed 1-1, match finished 3-3).

I have been playing around with the league table tab and think I have figured out how to rank the table in terms of most points etc., again though I'm no expert and this could be totally wrong.

The thing I am struggling with and require help with is:

1. When I input the Prem Fixture results how can I link that to the Office Fixtures so that the correct points are automatically calculated and the league table is adjusted accordingly?

Any help, advice, step-by-step guides would be greatly appreciated.

Thanks in advance

Goonerruss

 

[zago12]

tsk ustad sagol