Try in AD275:
=IFERROR(INDEX($AG$96:$CN$259,MATCH($AC275,$AB$96:$AB$259,0)+MATCH(INDEX($AC$273:$AC275,MATCH(10^10,$AB$273:$AB275)+1),$AD$23:$AD$44,0)+1,MATCH(AD$271,$AG$85:$CN$85,0)),"")
copied down to AD280, then copied across all the columns.
then you can copy AD275 to CK280 and paste to AD283, then paste to AD291, etc to get all figures..
Bookmarks