Football Fixture list generator

rick8651 No apologies needed! See attached. I created a fixture list from the website I mentioned earlier and dumped it into column L on the Fixtures sheet, just for your reference. Then I used Power Query to re-shape the list to something more useful. Now, I didn't include the PQ part, but the end result is copied into columns O to Q. Then I added a column to the Dummy Table and assigned a number to each team so that you can use a lookup formula to pick-up the team names based on the numbers in the fixtures table (Home and Away) in columns P and Q.

The best way to learn Excel is to look at the formulae I used, read about how they work and practice, practice.

Attaching your own file with some extras. I hope you'll find it helpful. Good luck!