Formation | Scored | Conceeded | Home / Away | Result | Points |
4-4-2 | 4 | 2 | H | W | 3 |
3-5-2 | 2 | 2 | H | D | 1 |
4-3-3 | 0 | 1 | A | L | 0 |
4-4-2 | 1 | 1 | A | D | 1 |
<tbody>
</tbody>
Formation | Total Conceeded | Total Scored | #W | #D | #L | Total Points |
4-4-2 | ? | ? | ? | ? | ? | ? |
<tbody>
</tbody>
Based on the table above does anybody know formulas that can return the following information. I have been trying to use a LOOKUP function but having no joy.
Any help on this would be massively appreciated.
Thanks