Spreadsheet: 162072d1339707803-using-vlookup-and-if-formula-in-european-football-calculation-zzz-sample-scnl-fantasy-european-championship-2012-rev1
Sheet: Entry

SCNL Fantasy European Championship 2012
Welcome to the "SCNL Fantasy European Championship 2012", which will take place in the fantastic location of Port Harcourt... through the satellite link-up with Poland & Ukraine!!!
The game is very easy… everybody can play and win… it is not important to believe to be an expert of soccer to win… the most important thing is to be lucky!! :-)
The registration is very cheap, since one coupon costs only 2.000 NGN (or 10 Euro) - Each one can play more than one coupon (two, three, etc.)!!
Time limit to submit to me your coupon: Friday, 8th June 2012, 4.00 p.m.
The jackpot will be shared out like this: |  |  |  |  |  |  |  |  |  |  | Events |  | POINTS
1^ ranking |  | 45% of jackpot |  |  |  |  |  |  |  |  | 1st Round Games |  | 107
2^ ranking |  | 25% of jackpot |  |  |  |  |  |  |  |  | 1st Round Ranking |  | 0
3^ ranking |  | 15% of jackpot |  |  |  |  |  |  |  |  | Quarter Finals |  | 46
4^ ranking |  | 10% of jackpot |  |  |  |  |  |  |  |  | Semi-Finals |  | 35
5^ ranking |  | 5% of jackpot |  |  |  |  |  |  |  |  | Grand Finals |  | 30
 |  |  |  |  |  |  |  |  |  |  | Finals |  | 40
Let's hope that you will enjoy your time playing with this great game!!... GOOD LUCK!!!!!! |  |  |  |  |  |  |  |  |  |  | Specials |  | 0
 |  |  |  | Max Liberatore & [NAME] |  |  |  |  |  |  | Total |  | 258
 | First Round
Group | Match | Prevision | End result | Points | Rules and Awarding
Group A | Poland - Greece | X | 1-1 | 0 | 1) You have to choose, for each match of the First Round, your prevision (1, X, 2) and the end result of the match:
Group A | Russia - Czech Republic | 1 | 4-1 | 10 | - for each right prevision: 3 points
Group B | Netherlands - Denmark | 2 | 0-1 | 10 | - for each right end result: 7 points
Group B | Germany - Portugal | 1 | 1-0 | 10
Group C | Spain - Italy | X | 1-1 | 10 | BONUS:
Group C | Republic of Ireland - Croatia | 2 | 1-3 | 10 | The 8 matches highlighted in red color will be considered as "star-matches".
Group D | France - England | X | 1-1 | 10 | For these "star-matches", the above mentioned points will be authomatically doubled:
Group D | Ukraine - Sweden | 1 | 2-1 | 10 | - for each right prevision: 6 points
Group A | Greece - Czech Republic | 1 | 2-1 | 0 | - for each right end result: 14 points
Group A | Poland - Russia | 2 | 1-2 | 0
Group B | Denmark - Portugal | 2 | 1-2 | 0 | 2) You have to indicate, for each Group, the final position of each team at the end of the First Round:
Group B | Netherlands - Germany | 2 | 1-2 | 3 | - for each right prevision: 5 points
Group C | Italy - Croatia | 1 | 2-1 | 10
Group C | Spain - Republic of Ireland | 1 | 2-1 | 3 | Group A |  | Ranking | 0 |  | Group B |  | Ranking | 0
Group D | Sweden - England | 2 | 1-2 | 3 | Poland |  | 1 | 0 |  | Netherlands |  | 4 | 0
Group D | Ukraine - France | 2 | 1-2 | 0 | Greece |  | 3 | 0 |  | Denmark |  | 3 | 0
Group A | Czech Republic - Poland | 2 | 1-2 | 0 | Russia |  | 2 | 0 |  | Germany |  | 1 | 0
Group A | Greece - Russia | 2 | 1-2 | 3 | Czech Republic |  | 4 | 0 |  | Portugal |  | 2 | 0
Group B | Portugal - Netherlands | 1 | 2-1 | 0
Group B | Denmark - Germany | 2 | 1-2 | 10 | Group C |  | Ranking | 0 |  | Group D |  | Ranking | 0
Group C | Croatia - Spain | 1 | 2-1 | 0 | Spain |  | 2 | 0 |  | Ukraine |  | 4 | 0
Group C | Italy - Republic of Ireland | 1 | 2-1 | 3 | Italy |  | 1 | 0 |  | Sweden |  | 3 | 0
Group D | England - Ukraine | 1 | 2-1 | 0 | Republic of Ireland |  | 4 | 0 |  | France |  | 2 | 0
Group D | Sweden - France | 2 | 1-2 | 0 | Croatia |  | 3 | 0 |  | England |  | 1 | 0
Jolly Team | England |  |  | 2 | 3) You have to choose , among the 16 teams of the First Round, one "Jolly Team" - All the goals scored
 |  |  |  |  | and scored against this team in the First Round will become additional points
 |  |  |  | Points
Teams qualified to the Quarter Finals | Group A | 1^ | Poland | 6 | 4) For each group, you have to choose the teams which will be qualified to the Quarter Finals:
 |  | 2^ | Russia |  | - if you mark both, in the right ranking: 10 points
 | Group B | 1^ | Germany | 4 | - if you mark both, in the wrong ranking: 6 points
 |  | 2^ | Portugal |  | - if you mark one team only, in the right ranking: 4 points
 | Group C | 1^ | Italy | 1 | - if you mark one team only, in the wrong ranking: 1 point
 |  | 2^ | Croatia
 | Group D | 1^ | England | 10 | BONUS: If you mark at least 6 teams qualified to the Round of 16: 25 additional points
 |  | 2^ | France
BONUS |  |  |  | 25
Top goalscorer's team |  | England |  |  | 5) You have to choose the team of the top goalscorer at the end of the First Round:
 |  |  |  |  | - if you mark it: 25 points
Match with more goals |  | England - Ukraine |  |  | 6) You have to choose, among the 24 matches of the First Round, which one will have the major number of goals:
 |  |  |  |  | - if you mark it: 15 points
Team with the highest numbers of goals scored |  | England |  |  | 7) You have to choose the team with the highest numbers of goals scored at the end of the First Round:
 |  |  |  |  | - if you mark it: 10 points
Team with the lowest numbers of goals scored |  | Ukraine |  |  | 8) You have to choose the team with the lowest numbers of goals scored at the end of the First Round:
 |  |  |  |  | - if you mark it: 10 points
Team with the highest numbers of goals scored against |  | England |  |  | 9) You have to choose the team with the highest numbers of goals scored against at the end of the First Round:
 |  |  |  |  | - if you mark it: 10 points
Team with the lowest numbers of goals scored against |  | Ukraine |  |  | 10) You have to choose the team with the lowest numbers of goals scored against at the end of the First Round:
 |  |  |  |  | - if you mark it: 10 points
 | Semi Finals
 |  |  |  | Points
Teams qualified to the Semi Finals | 1^ | Poland |  | 35 | 11) You have to choose the teams which will be qualified to the Semi Finals:
 | 2^ | Germany |  |  | - if you mark all the teams: 35 points |  |  |  | - if you mark 3 teams: 25 points
 | 3^ | Italy |  |  | - if you mark 2 teams: 15 points |  |  |  | - if you mark 1 team: 5 points
 | 4^ | England
 | Grand Finals
 |  |  |  | Points
Teams qualified to the Grand Final | 1^ | Italy |  | 30 | 12) You have to choose the teams which will be qualified to the Grand Final:
 | 2^ | England |  |  | - if you mark all the teams: 30 points |  |  |  | - if you mark 1 team: 15 points
 | Finals
World Champion | 1^ | England |  | 40 | 13) You have to choose the World Champion:
 |  |  |  |  | - if you mark it: 40 points
 | Specials
 |  |  |  | Points
Top goalscorer's team |  | England |  |  | 14) You have to choose the team of the top goalscorer at the end of the World Cup:
 |  |  |  |  | - if you mark it: 35 points
Team with the highest numbers of goals scored at the end of the World Cup (*) |  | England |  |  | 15) You have to choose the team with the highest numbers of goals scored at the end of the World Cup:
 |  |  |  |  | - if you mark it: 25 points
Team with the lowest numbers of goals scored against at the end of the World Cup (*) |  | Ukraine |  |  | 16) You have to choose the team with the lowest numbers of goals scored against at the end of the World Cup:
 |  |  |  |  | - if you mark it: 25 points
(*) = | including possible overtimes but excluding possible following penalties
(NOTE) = | in case of multiple result (i.e., two top goalscorers, or two teams with the same highest numbers of golas scored, etc...), the total points foreseen will be given to
 | all the participants guessing at least one of the results