Hi,
I haven’t used VLOOKUP or IF formulas for some time now, but find myself in need of one! My colleague and I are developing a site that utilises football (or soccer!) result data. We have found a supplier who can issue us with an Excel sheet comprising all previous football results from the season. This data is presented to us as the attached Excel document.
The columns consist of HOME TEAM, AWAY TEAM, HOME TEAM GOALS and AWAY TEAM GOALS. We would like to develop a formula that is able to ‘Look Up’ historic goals scored data, and display it against the forthcoming games schedule. For example, we would like to be able to have the forthcoming fixtures in a list like so…
AGS Arsenal v Everton AGS
AGS Liverpool v Tottenham AGS
AGS Stoke v Fulham AGS
….and so on
Next to each team (shown above as AGS), we would like to display the specific teams AVERAGE GOALS SCORED in their previous game. We have all the raw data from our supplier, we just require a formula to help us harvest it!
Any help would be greatly appreciated
Bookmarks