Hello all.
I have managed to put together a formula for soccer prediction.
The whole idea is based on simply adding the Home results against the Away results of the two teams
I have inserted the external link so as to download the league tables and it works fine.
What I wish to do is to be able to have the spreadsheet work once the fixtures are inserted.
The main idea is that we have two different tables
A (In Sheet 1) The newly refreshed league table and B ( In sheet 2) the fixtures.
The target is to go to the fixtures and see what the formula predicts for each fixture, based on the updated league table.
The formula works if three values for each team playing with each other are calculated.
Home Wins, Draws and Losses for Home Team, and Away Wins Draws and losses for the Away team.
If I ve given you a headache then you know EXACTLY how I feel.....
The problem is that I need a VLOOKUP formula or something to calculate as folows
From the league table to take the Home Wins, the Draws and the losses of the Home Playing team and place them in a row, and for the Away Team the Away Wins the Away Draws and the Away Losses and again put them in a row. From there all I need to do is to add the predicting formula....
Can Anybody help?
I will be obliged.
Bookmarks