I have a pivot table which lists football teams down column A (home team) and across row 2 (away team).

The values in the pivot table are the game week that the fixtures will be played. From this, I've been able to create an Index Match which summaries the fixtures almost as required. The problem is that in some game weeks, a team may have two fixtures (which is where my limitations of Excel comes in). The below formula has 2 x index match and will stop searching for additional matches once a match has been returned.

I have converted my Excel to a Google Sheet and pasted the link below. The formulas are within C25:I25 and an example of what I'm trying to achieve in F26:F27 can be found in K26:K27.

I have converted my Excel to a Google Sheet and pasted the link below. The formulas are within C25:I25 and an example of what I'm trying to achieve in F26:F27 can be found in K26:K27.

If anyone has any suggestions I'd be super grateful.

Thanks

Ryan

Excel Formula:

`=IFERROR(IFERROR(INDEX($B$2:$U$2,MATCH(C$24,$B3:$U3,0))&" (H)",INDEX($A$3:$A$22,MATCH(C$24,$B$3:$B$22,0))&" (A)"),"")`

### Fixtures Index/Match fix

Sheet1 Min of Gameweek,Column Labels Row Labels,ARS,AVL,BHA,BUR,CHE,CRY,EVE,FUL,LEE,LEI,LIV,MCI,MUN,NEW,SHU,SOU,TOT,WBA,WHU ARS,8,38,12,15,18,33,32,24,6,30,25,21,19,4,13,28,35,2 AVL,23,9,13,38,15,0,30,6,25,4,32,35,19,2,7,0,33,22 BHA,16,24,8,1,25,31,20,34,27,10,37,3,29,14,11,21,6,36 BUR,27,20,23,7,9

docs.google.com