Goals tell you what happened. xG tells you what should have happened, based on the quality of the chances created. Teams that create good chances tend to keep scoring.
On the chart, a team is above the dashed line y = x. What does it mean?
On the chart, look at Argentina, Senegal, Ghana and Spain: which of them are above the dashed line (more goals than their xG)?
Argentina has an xG of 2.10 per match but scores 1.57. Senegal has an xG of 1.01 but scores 1.71. Which statement is most accurate?
VLOOKUP: fetch a value from another table
VLOOKUP(what, where, which column, FALSE) finds a value in the first column of a table and returns the value from another column. Example:
| Club | Country | Budget (€M) |
|---|---|---|
| PSG | France | 700 |
| Arsenal | England | 350 |
| Barcelona | Spain | 600 |
=VLOOKUP("Arsenal", A:C, 3, FALSE)
→ 350Your turn: fetch each country's xg_per_match (4th column of ⚡ xG Data).
Type ( , ; or an operator, then click a column or a cell to insert it.
Editing 📝 My Analysis!M4
| A | M | |
|---|---|---|
| 1 | FIFA World Cup 2026 — My Analysis | |
| 2 | ||
| 3 | Team | xG/Match |
| 4 | Spain | |
| 5 | Portugal | |
| 6 | France | |
| 7 | Germany | |
| 8 | England | |
| 9 | Netherlands | |
| 10 | Norway | |
| 11 | Austria | |
| 12 | Belgium | |
| 13 | Croatia | |
| 14 | Switzerland | |
| 15 | Scotland | |
| 16 | Turkey | |
| 17 | Argentina | |
| 18 | Brazil | |
| 19 | Colombia | |
| 20 | Uruguay | |
| 21 | Ecuador | |
| 22 | Paraguay | |
| 23 | USA | |
| 24 | Mexico | |
| 25 | Canada | |
| 26 | Morocco | |
| 27 | Senegal | |
| 28 | Nigeria | |
| 29 | Ghana | |
| 30 | Japan | |
| 31 | South Korea | |
| 32 | Saudi Arabia | |
| 33 | Australia |
Column M — xG per match. In M4, use VLOOKUP to fetch Spain's xg_per_match from ⚡ xG Data.
Function names in your language
| EN | FR | ES | IT |
|---|---|---|---|
COUNTIF | NB.SI | CONTAR.SI | CONTA.SE |
COUNTIFS | NB.SI.ENS | CONTAR.SI.CONJUNTO | CONTA.PIÙ.SE |
VLOOKUP | RECHERCHEV | BUSCARV | CERCA.VERT |
Both work here, and you can separate arguments with , or ; — just like in a real spreadsheet.