Sports League Schedule Maker-- Combining Two Conference Schedules into One

Hello GHURST2 and Welcome to Excel Forum.
This proposal uses the following on both the conference 1 and 2 sheets:
Cell A37: ='Weekly Schedule'!A4
Cells B37:J37 =IF(INDEX(B$3:B$35,MATCH($A37,$AN$3:$AN$35,0))="Bye","",MIN(INDEX(B$3:B$35,MATCH($A37,$AN$3:$AN$35,0)),B$2))
Cells B38:J38 =IF(INDEX(B$3:B$35,MATCH($A37,$AN$3:$AN$35,0))="Bye","",MAX(INDEX(B$3:B$35,MATCH($A37,$AN$3:$AN$35,0)),B$2))
Cells AJ2:AJ10 =IF(COUNTIFS(B$37:J$37,AL2),INDEX(AK$2:AK$10,MATCH(INDEX(B$38:J$38,MATCH(AL2,B$37:J$37,0)),AL$2:AL$10,0)),"")
On the Weekly Schedule sheet, cells G6:H13

Formula:

Please Login or Register  to view this content.

To change the weekly schedule change the week in cell A4 on the Weekly Schedule sheet.
Note that columns A:AJ on both conference sheets may be hidden again, I just left them unhidden so that you could see what was done.
Let us know if you have any questions.

I feel that the following method lends itself better to generating multiple weeks:
On the Conference 1 and 2 sheets populate AP37:AX45 using: =IF(AP3="BYE","",MIN(MID(AP3,6,1)+0,RIGHT(AP3,1))&" "&MAX(MID(AP3,6,1)+0,RIGHT(AP3,1)))
Populate AP48:AX56 using: =IF(AND(AP37<>"",COUNTIFS($AP37:AP37,AP37)=1),AP3,"")
On the Weekly Schedule sheet rows are populated using:

Formula:

Please Login or Register  to view this content.

Let us know if you have any questions.