The Rank result is then used in aVLOOKUP formula with CHOOSEto return a sorted list of teams in column A of the league table. Tip:we use CHOOSE to get around the limitation of VLOOKUP not being able to lookup to the left. You could also useINDEX & MATCH. Fonts and Conditional Formatti...
The Rank result is then used in aVLOOKUP formula with CHOOSEto return a sorted list of teams in column A of the league table. Tip:we use CHOOSE to get around the limitation of VLOOKUP not being able to lookup to the left. You could also useINDEX & MATCH. Fonts and Conditional Formatti...