Look up values in a row and pull corresponding datat to a cell in the same row

[senechia]

The attached is a game schedule for a pool league. I'm trying to pull the data from the Game Table to the Team Table to the corresponding matches. Eg. If i want to pull in the opponent From Game 1 on 4/11(7 vs 3) and put the opponent 3 under 7 and also put opponent 7 under 3

[TABLE="width: 1002"]
<tbody>[TR]
[TD]Date[/TD]
[TD][/TD]
[TD="colspan: 4"]Game 1[/TD]
[TD="colspan: 4"]Game 2[/TD]
[TD="colspan: 3"]Game 3[/TD]
[TD][/TD]
[TD="colspan: 3"]Game4[/TD]
[TD][/TD]
[TD][/TD]
[TD]1[/TD]
[TD]2[/TD]
[TD]3[/TD]
[TD]4[/TD]
[TD]5[/TD]
[TD]6[/TD]
[TD]7[/TD]
[TD]8[/TD]
[/TR]
[TR]
[TD="align: right"]2/7/2019[/TD]
[TD][/TD]
[TD]1[/TD]
[TD]vs[/TD]
[TD]2[/TD]
[TD][/TD]
[TD]3[/TD]
[TD]vs[/TD]
[TD]4[/TD]
[TD][/TD]
[TD]5[/TD]
[TD]vs[/TD]
[TD]6[/TD]
[TD][/TD]
[TD]7[/TD]
[TD]vs[/TD]
[TD]8[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]2/14/2019[/TD]
[TD][/TD]
[TD]6[/TD]
[TD]vs[/TD]
[TD]8[/TD]
[TD][/TD]
[TD]5[/TD]
[TD]vs[/TD]
[TD]7[/TD]
[TD][/TD]
[TD]2[/TD]
[TD]vs[/TD]
[TD]4[/TD]
[TD][/TD]
[TD]1[/TD]
[TD]vs[/TD]
[TD]3[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]2/21/2019[/TD]
[TD][/TD]
[TD]5[/TD]
[TD]vs[/TD]
[TD]4[/TD]
[TD][/TD]
[TD]1[/TD]
[TD]vs[/TD]
[TD]8[/TD]
[TD][/TD]
[TD]7[/TD]
[TD]vs[/TD]
[TD]3[/TD]
[TD][/TD]
[TD]2[/TD]
[TD]vs[/TD]
[TD]6[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]2/28/2019[/TD]
[TD][/TD]
[TD]3[/TD]
[TD]vs[/TD]
[TD]6[/TD]
[TD][/TD]
[TD]7[/TD]
[TD]vs[/TD]
[TD]2[/TD]
[TD][/TD]
[TD]1[/TD]
[TD]vs[/TD]
[TD]5[/TD]
[TD][/TD]
[TD]8[/TD]
[TD]vs[/TD]
[TD]4[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]3/7/2019[/TD]
[TD][/TD]
[TD]7[/TD]
[TD]vs[/TD]
[TD]1[/TD]
[TD][/TD]
[TD]4[/TD]
[TD]vs[/TD]
[TD]6[/TD]
[TD][/TD]
[TD]3[/TD]
[TD]vs[/TD]
[TD]8[/TD]
[TD][/TD]
[TD]5[/TD]
[TD]vs[/TD]
[TD]2[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]3/14/2019[/TD]
[TD][/TD]
[TD]2[/TD]
[TD]vs[/TD]
[TD]3[/TD]
[TD][/TD]
[TD]8[/TD]
[TD]vs[/TD]
[TD]5[/TD]
[TD][/TD]
[TD]4[/TD]
[TD]vs[/TD]
[TD]1[/TD]
[TD][/TD]
[TD]6[/TD]
[TD]vs[/TD]
[TD]7[/TD]
[TD][/TD]
[TD="colspan: 9"]How do I return the values from the table on the left to the table above?[/TD]
[/TR]
[TR]
[TD="align: right"]3/21/2019[/TD]
[TD][/TD]
[TD]4[/TD]
[TD]vs[/TD]
[TD]7[/TD]
[TD][/TD]
[TD]6[/TD]
[TD]vs[/TD]
[TD]1[/TD]
[TD][/TD]
[TD]8[/TD]
[TD]vs[/TD]
[TD]2[/TD]
[TD][/TD]
[TD]3[/TD]
[TD]vs[/TD]
[TD]5[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]3/28/2019[/TD]
[TD][/TD]
[TD]5[/TD]
[TD]vs[/TD]
[TD]6[/TD]
[TD][/TD]
[TD]7[/TD]
[TD]vs[/TD]
[TD]8[/TD]
[TD][/TD]
[TD]3[/TD]
[TD]vs[/TD]
[TD]4[/TD]
[TD][/TD]
[TD]1[/TD]
[TD]vs[/TD]
[TD]2[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]4/4/2019[/TD]
[TD][/TD]
[TD]2[/TD]
[TD]vs[/TD]
[TD]4[/TD]
[TD][/TD]
[TD]1[/TD]
[TD]vs[/TD]
[TD]3[/TD]
[TD][/TD]
[TD]5[/TD]
[TD]vs[/TD]
[TD]7[/TD]
[TD][/TD]
[TD]6[/TD]
[TD]vs[/TD]
[TD]8[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]4/11/2019[/TD]
[TD][/TD]
[TD]7[/TD]
[TD]vs[/TD]
[TD]3[/TD]
[TD][/TD]
[TD]2[/TD]
[TD]vs[/TD]
[TD]6[/TD]
[TD][/TD]
[TD]1[/TD]
[TD]vs[/TD]
[TD]8[/TD]
[TD][/TD]
[TD]5[/TD]
[TD]vs[/TD]
[TD]4[/TD]
[TD][/TD]
[TD][/TD]
[TD]Example:[/TD]
[TD][/TD]
[TD]7[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]3[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]4/18/2019[/TD]
[TD][/TD]
[TD]1[/TD]
[TD]vs[/TD]
[TD]5[/TD]
[TD][/TD]
[TD]8[/TD]
[TD]vs[/TD]
[TD]4[/TD]
[TD][/TD]
[TD]7[/TD]
[TD]vs[/TD]
[TD]2[/TD]
[TD][/TD]
[TD]3[/TD]
[TD]vs[/TD]
[TD]6[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]4/25/2019[/TD]
[TD][/TD]
[TD]3[/TD]
[TD]vs[/TD]
[TD]8[/TD]
[TD][/TD]
[TD]5[/TD]
[TD]vs[/TD]
[TD]2[/TD]
[TD][/TD]
[TD]4[/TD]
[TD]vs[/TD]
[TD]6[/TD]
[TD][/TD]
[TD]7[/TD]
[TD]vs[/TD]
[TD]1[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

 

[DanteAmor]

​Put the game number in cell P1

Hoja1

[TABLE="class: grid, width: 500"]
<tbody>[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=cacaca]#cacaca[/URL] "]
[TD][/TD]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[TD]D[/TD]
[TD]E[/TD]
[TD]F[/TD]
[TD]G[/TD]
[TD]H[/TD]
[TD]I[/TD]
[TD]J[/TD]
[TD]K[/TD]
[TD]L[/TD]
[TD]M[/TD]
[/TR]
[TR]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=cacaca]#cacaca[/URL] , align: center"]1[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[/TR]
[TR]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=cacaca]#cacaca[/URL] , align: center"]2[/TD]
[TD]Date[/TD]
[TD]Game 1[/TD]
[TD][/TD]
[TD][/TD]
[TD]Game 2[/TD]
[TD][/TD]
[TD][/TD]
[TD]Game 3[/TD]
[TD][/TD]
[TD][/TD]
[TD]Game4[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=cacaca]#cacaca[/URL] , align: center"]3[/TD]
[TD="align: right"]02/07/2019[/TD]
[TD="align: right"]1[/TD]
[TD="align: center"]vs[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]3[/TD]
[TD="align: center"]vs[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]5[/TD]
[TD="align: center"]vs[/TD]
[TD="align: right"]6[/TD]
[TD="align: right"]7[/TD]
[TD="align: center"]vs[/TD]
[TD="align: right"]8[/TD]
[/TR]
[TR]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=cacaca]#cacaca[/URL] , align: center"]4[/TD]
[TD="align: right"]2/14/2019[/TD]
[TD="align: right"]6[/TD]
[TD="align: center"]vs[/TD]
[TD="align: right"]8[/TD]
[TD="align: right"]5[/TD]
[TD="align: center"]vs[/TD]
[TD="align: right"]7[/TD]
[TD="align: right"]2[/TD]
[TD="align: center"]vs[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]1[/TD]
[TD="align: center"]vs[/TD]
[TD="align: right"]3[/TD]
[/TR]
[TR]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=cacaca]#cacaca[/URL] , align: center"]5[/TD]
[TD="align: right"]2/21/2019[/TD]
[TD="align: right"]5[/TD]
[TD="align: center"]vs[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]1[/TD]
[TD="align: center"]vs[/TD]
[TD="align: right"]8[/TD]
[TD="align: right"]7[/TD]
[TD="align: center"]vs[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]2[/TD]
[TD="align: center"]vs[/TD]
[TD="align: right"]6[/TD]
[/TR]
[TR]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=cacaca]#cacaca[/URL] , align: center"]6[/TD]
[TD="align: right"]2/28/2019[/TD]
[TD="align: right"]3[/TD]
[TD="align: center"]vs[/TD]
[TD="align: right"]6[/TD]
[TD="align: right"]7[/TD]
[TD="align: center"]vs[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]1[/TD]
[TD="align: center"]vs[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]8[/TD]
[TD="align: center"]vs[/TD]
[TD="align: right"]4[/TD]
[/TR]
[TR]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=cacaca]#cacaca[/URL] , align: center"]7[/TD]
[TD="align: right"]03/07/2019[/TD]
[TD="align: right"]7[/TD]
[TD="align: center"]vs[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]4[/TD]
[TD="align: center"]vs[/TD]
[TD="align: right"]6[/TD]
[TD="align: right"]3[/TD]
[TD="align: center"]vs[/TD]
[TD="align: right"]8[/TD]
[TD="align: right"]5[/TD]
[TD="align: center"]vs[/TD]
[TD="align: right"]2[/TD]
[/TR]
[TR]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=cacaca]#cacaca[/URL] , align: center"]8[/TD]
[TD="align: right"]3/14/2019[/TD]
[TD="align: right"]2[/TD]
[TD="align: center"]vs[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]8[/TD]
[TD="align: center"]vs[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]4[/TD]
[TD="align: center"]vs[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]6[/TD]
[TD="align: center"]vs[/TD]
[TD="align: right"]7[/TD]
[/TR]
[TR]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=cacaca]#cacaca[/URL] , align: center"]9[/TD]
[TD="align: right"]3/21/2019[/TD]
[TD="align: right"]4[/TD]
[TD="align: center"]vs[/TD]
[TD="align: right"]7[/TD]
[TD="align: right"]6[/TD]
[TD="align: center"]vs[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]8[/TD]
[TD="align: center"]vs[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]3[/TD]
[TD="align: center"]vs[/TD]
[TD="align: right"]5[/TD]
[/TR]
[TR]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=cacaca]#cacaca[/URL] , align: center"]10[/TD]
[TD="align: right"]3/28/2019[/TD]
[TD="align: right"]5[/TD]
[TD="align: center"]vs[/TD]
[TD="align: right"]6[/TD]
[TD="align: right"]7[/TD]
[TD="align: center"]vs[/TD]
[TD="align: right"]8[/TD]
[TD="align: right"]3[/TD]
[TD="align: center"]vs[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]1[/TD]
[TD="align: center"]vs[/TD]
[TD="align: right"]2[/TD]
[/TR]
[TR]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=cacaca]#cacaca[/URL] , align: center"]11[/TD]
[TD="align: right"]04/04/2019[/TD]
[TD="align: right"]2[/TD]
[TD="align: center"]vs[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]1[/TD]
[TD="align: center"]vs[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]5[/TD]
[TD="align: center"]vs[/TD]
[TD="align: right"]7[/TD]
[TD="align: right"]6[/TD]
[TD="align: center"]vs[/TD]
[TD="align: right"]8[/TD]
[/TR]
[TR]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=cacaca]#cacaca[/URL] , align: center"]12[/TD]
[TD="align: right"]04/11/2019[/TD]
[TD="align: right"]7[/TD]
[TD="align: center"]vs[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]2[/TD]
[TD="align: center"]vs[/TD]
[TD="align: right"]6[/TD]
[TD="align: right"]1[/TD]
[TD="align: center"]vs[/TD]
[TD="align: right"]8[/TD]
[TD="align: right"]5[/TD]
[TD="align: center"]vs[/TD]
[TD="align: right"]4[/TD]
[/TR]
[TR]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=cacaca]#cacaca[/URL] , align: center"]13[/TD]
[TD="align: right"]4/18/2019[/TD]
[TD="align: right"]1[/TD]
[TD="align: center"]vs[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]8[/TD]
[TD="align: center"]vs[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]7[/TD]
[TD="align: center"]vs[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]3[/TD]
[TD="align: center"]vs[/TD]
[TD="align: right"]6[/TD]
[/TR]
[TR]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=cacaca]#cacaca[/URL] , align: center"]14[/TD]
[TD="align: right"]4/25/2019[/TD]
[TD="align: right"]3[/TD]
[TD="align: center"]vs[/TD]
[TD="align: right"]8[/TD]
[TD="align: right"]5[/TD]
[TD="align: center"]vs[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]4[/TD]
[TD="align: center"]vs[/TD]
[TD="align: right"]6[/TD]
[TD="align: right"]7[/TD]
[TD="align: center"]vs[/TD]
[TD="align: right"]1[/TD]
[/TR]
</tbody>[/TABLE]


Hoja1

[TABLE="class: grid, width: 500"]
<colgroup><col style="font-weight:bold; width:30px; "><col style="width:43px;"><col style="width:43px;"><col style="width:43px;"><col style="width:43px;"><col style="width:43px;"><col style="width:43px;"><col style="width:43px;"><col style="width:43px;"></colgroup><tbody>[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=cacaca]#cacaca[/URL] "]
[TD] [/TD]
[TD]O[/TD]
[TD]P[/TD]
[TD]Q[/TD]
[TD]R[/TD]
[TD]S[/TD]
[TD]T[/TD]
[TD]U[/TD]
[TD]V[/TD]
[/TR]
[TR]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=cacaca]#cacaca[/URL] , align: center"]1[/TD]
[TD]Game[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=ffff00]#ffff00[/URL] , align: right"]1[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=cacaca]#cacaca[/URL] , align: center"]2[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=b8cce4]#b8cce4[/URL] , align: right"]1[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=b8cce4]#b8cce4[/URL] , align: right"]2[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=b8cce4]#b8cce4[/URL] , align: right"]3[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=b8cce4]#b8cce4[/URL] , align: right"]4[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=b8cce4]#b8cce4[/URL] , align: right"]5[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=b8cce4]#b8cce4[/URL] , align: right"]6[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=b8cce4]#b8cce4[/URL] , align: right"]7[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=b8cce4]#b8cce4[/URL] , align: right"]8[/TD]
[/TR]
[TR]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=cacaca]#cacaca[/URL] , align: center"]3[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]1[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=cacaca]#cacaca[/URL] , align: center"]4[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD="align: right"]8[/TD]
[TD] [/TD]
[TD="align: right"]6[/TD]
[/TR]
[TR]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=cacaca]#cacaca[/URL] , align: center"]5[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]4[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=cacaca]#cacaca[/URL] , align: center"]6[/TD]
[TD] [/TD]
[TD] [/TD]
[TD="align: right"]6[/TD]
[TD] [/TD]
[TD] [/TD]
[TD="align: right"]3[/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=cacaca]#cacaca[/URL] , align: center"]7[/TD]
[TD="align: right"]7[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD="align: right"]1[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=cacaca]#cacaca[/URL] , align: center"]8[/TD]
[TD] [/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]2[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=cacaca]#cacaca[/URL] , align: center"]9[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD="align: right"]7[/TD]
[TD] [/TD]
[TD] [/TD]
[TD="align: right"]4[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=cacaca]#cacaca[/URL] , align: center"]10[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD="align: right"]6[/TD]
[TD="align: right"]5[/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=cacaca]#cacaca[/URL] , align: center"]11[/TD]
[TD] [/TD]
[TD="align: right"]4[/TD]
[TD] [/TD]
[TD="align: right"]2[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=cacaca]#cacaca[/URL] , align: center"]12[/TD]
[TD] [/TD]
[TD] [/TD]
[TD="align: right"]7[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD="align: right"]3[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=cacaca]#cacaca[/URL] , align: center"]13[/TD]
[TD="align: right"]5[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD="align: right"]1[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=cacaca]#cacaca[/URL] , align: center"]14[/TD]
[TD] [/TD]
[TD] [/TD]
[TD="align: right"]8[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD="align: right"]3[/TD]
[/TR]
</tbody>[/TABLE]



[TABLE="class: grid, width: 800"]
<tbody>[TR]
[TD]Cell[/TD]
[TD]Formula[/TD]
[/TR]
[TR]
[TD]O3[/TD]
[TD]=IF(OFFSET($A3,0,($P$1*3)-2)=O$2,OFFSET($A3,0,($P$1*3)),IF(OFFSET($A3,0,($P$1*3))=O$2,OFFSET($A3,0,($P$1*3)-2),""))[/TD]
[/TR]
</tbody>[/TABLE]

 

[James Lever]

Another possible take, row 4 is the first row of results, formula posted at the bottom just copy to fill in the rest of the table.

[TABLE="width: 722"]
<colgroup><col><col><col><col><col><col><col><col><col><col span="3"><col><col span="3"><col><col><col><col span="3"><col><col></colgroup><tbody>[TR]
[TD]Col A[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Col Q[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD="colspan: 8"]Game 1[/TD]
[/TR]
[TR]
[TD]Date[/TD]
[TD="colspan: 4"]Game 1[/TD]
[TD="colspan: 4"]Game 2[/TD]
[TD="colspan: 3"]Game 3[/TD]
[TD] [/TD]
[TD="colspan: 3"]Game4[/TD]
[TD]1[/TD]
[TD]2[/TD]
[TD]3[/TD]
[TD]4[/TD]
[TD]5[/TD]
[TD]6[/TD]
[TD]7[/TD]
[TD]8[/TD]
[/TR]
[TR]
[TD]02/07/2019[/TD]
[TD]1[/TD]
[TD]vs[/TD]
[TD]2[/TD]
[TD] [/TD]
[TD]3[/TD]
[TD]vs[/TD]
[TD]4[/TD]
[TD] [/TD]
[TD]5[/TD]
[TD]vs[/TD]
[TD]6[/TD]
[TD] [/TD]
[TD]7[/TD]
[TD]vs[/TD]
[TD]8[/TD]
[TD]2[/TD]
[TD]1[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]2/14/2019[/TD]
[TD]6[/TD]
[TD]vs[/TD]
[TD]8[/TD]
[TD] [/TD]
[TD]5[/TD]
[TD]vs[/TD]
[TD]7[/TD]
[TD] [/TD]
[TD]2[/TD]
[TD]vs[/TD]
[TD]4[/TD]
[TD] [/TD]
[TD]1[/TD]
[TD]vs[/TD]
[TD]3[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD]8[/TD]
[TD] [/TD]
[TD]6[/TD]
[/TR]
[TR]
[TD]2/21/2019[/TD]
[TD]5[/TD]
[TD]vs[/TD]
[TD]4[/TD]
[TD] [/TD]
[TD]1[/TD]
[TD]vs[/TD]
[TD]8[/TD]
[TD] [/TD]
[TD]7[/TD]
[TD]vs[/TD]
[TD]3[/TD]
[TD] [/TD]
[TD]2[/TD]
[TD]vs[/TD]
[TD]6[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD]5[/TD]
[TD]4[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]2/28/2019[/TD]
[TD]3[/TD]
[TD]vs[/TD]
[TD]6[/TD]
[TD] [/TD]
[TD]7[/TD]
[TD]vs[/TD]
[TD]2[/TD]
[TD] [/TD]
[TD]1[/TD]
[TD]vs[/TD]
[TD]5[/TD]
[TD] [/TD]
[TD]8[/TD]
[TD]vs[/TD]
[TD]4[/TD]
[TD] [/TD]
[TD] [/TD]
[TD]6[/TD]
[TD] [/TD]
[TD] [/TD]
[TD]3[/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]03/07/2019[/TD]
[TD]7[/TD]
[TD]vs[/TD]
[TD]1[/TD]
[TD] [/TD]
[TD]4[/TD]
[TD]vs[/TD]
[TD]6[/TD]
[TD] [/TD]
[TD]3[/TD]
[TD]vs[/TD]
[TD]8[/TD]
[TD] [/TD]
[TD]5[/TD]
[TD]vs[/TD]
[TD]2[/TD]
[TD]7[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD]1[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]3/14/2019[/TD]
[TD]2[/TD]
[TD]vs[/TD]
[TD]3[/TD]
[TD] [/TD]
[TD]8[/TD]
[TD]vs[/TD]
[TD]5[/TD]
[TD] [/TD]
[TD]4[/TD]
[TD]vs[/TD]
[TD]1[/TD]
[TD] [/TD]
[TD]6[/TD]
[TD]vs[/TD]
[TD]7[/TD]
[TD] [/TD]
[TD]3[/TD]
[TD]2[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]3/21/2019[/TD]
[TD]4[/TD]
[TD]vs[/TD]
[TD]7[/TD]
[TD] [/TD]
[TD]6[/TD]
[TD]vs[/TD]
[TD]1[/TD]
[TD] [/TD]
[TD]8[/TD]
[TD]vs[/TD]
[TD]2[/TD]
[TD] [/TD]
[TD]3[/TD]
[TD]vs[/TD]
[TD]5[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD]7[/TD]
[TD] [/TD]
[TD] [/TD]
[TD]4[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]3/28/2019[/TD]
[TD]5[/TD]
[TD]vs[/TD]
[TD]6[/TD]
[TD] [/TD]
[TD]7[/TD]
[TD]vs[/TD]
[TD]8[/TD]
[TD] [/TD]
[TD]3[/TD]
[TD]vs[/TD]
[TD]4[/TD]
[TD] [/TD]
[TD]1[/TD]
[TD]vs[/TD]
[TD]2[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD]6[/TD]
[TD]5[/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]04/04/2019[/TD]
[TD]2[/TD]
[TD]vs[/TD]
[TD]4[/TD]
[TD] [/TD]
[TD]1[/TD]
[TD]vs[/TD]
[TD]3[/TD]
[TD] [/TD]
[TD]5[/TD]
[TD]vs[/TD]
[TD]7[/TD]
[TD] [/TD]
[TD]6[/TD]
[TD]vs[/TD]
[TD]8[/TD]
[TD] [/TD]
[TD]4[/TD]
[TD] [/TD]
[TD]2[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]04/11/2019[/TD]
[TD]7[/TD]
[TD]vs[/TD]
[TD]3[/TD]
[TD] [/TD]
[TD]2[/TD]
[TD]vs[/TD]
[TD]6[/TD]
[TD] [/TD]
[TD]1[/TD]
[TD]vs[/TD]
[TD]8[/TD]
[TD] [/TD]
[TD]5[/TD]
[TD]vs[/TD]
[TD]4[/TD]
[TD] [/TD]
[TD] [/TD]
[TD]7[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD]3[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]4/18/2019[/TD]
[TD]1[/TD]
[TD]vs[/TD]
[TD]5[/TD]
[TD] [/TD]
[TD]8[/TD]
[TD]vs[/TD]
[TD]4[/TD]
[TD] [/TD]
[TD]7[/TD]
[TD]vs[/TD]
[TD]2[/TD]
[TD] [/TD]
[TD]3[/TD]
[TD]vs[/TD]
[TD]6[/TD]
[TD]5[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD]1[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]4/25/2019[/TD]
[TD]3[/TD]
[TD]vs[/TD]
[TD]8[/TD]
[TD] [/TD]
[TD]5[/TD]
[TD]vs[/TD]
[TD]2[/TD]
[TD] [/TD]
[TD]4[/TD]
[TD]vs[/TD]
[TD]6[/TD]
[TD] [/TD]
[TD]7[/TD]
[TD]vs[/TD]
[TD]1[/TD]
[TD] [/TD]
[TD] [/TD]
[TD]8[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD]3[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="colspan: 20"]Formula in Q4: =IFNA(INDEX($B4:$D4,1,MATCH(Q$3,$B4:$D4,0)+IF($B4=Q$3,2,-2)),"")[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

 

[senechia]

I need all values in every feild for every game. Not just for the game in P1. Every cell in the table should be filled all the way up, down and across. Is there a way to do that? Thanks for your efforts

 

[senechia]

Example would be for 2/7/19 there would be 8 teams playing and the formulas in that row need to be completed

 

[DanteAmor]

I will check it

 

[DanteAmor]

Try:
In Cell O3

=IF($B3=O$2,$D3,IF($E3=O$2,$G3,IF($H3=O$2,$J3,IF($K3=O$2,$M3,IF($D3=O$2,$B3,IF($G3=O$2,$E3,IF($J3=O$2,$H3,IF($M3=O$2,$K3,""))))))))




Copy the formula down and to the right.


Hoja1

[TABLE="class: grid, width: 500"]
<colgroup><col style="font-weight:bold; width:30px; "><col style="width:75px;"><col style="width:23px;"><col style="width:23px;"><col style="width:23px;"><col style="width:23px;"><col style="width:23px;"><col style="width:23px;"><col style="width:23px;"><col style="width:23px;"><col style="width:23px;"><col style="width:23px;"><col style="width:23px;"><col style="width:23px;"><col style="width:23px;"><col style="width:89px;"><col style="width:43px;"><col style="width:43px;"><col style="width:43px;"><col style="width:43px;"><col style="width:43px;"><col style="width:43px;"><col style="width:43px;"></colgroup><tbody>[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=cacaca]#cacaca[/URL] "]
[TD] [/TD]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[TD]D[/TD]
[TD]E[/TD]
[TD]F[/TD]
[TD]G[/TD]
[TD]H[/TD]
[TD]I[/TD]
[TD]J[/TD]
[TD]K[/TD]
[TD]L[/TD]
[TD]M[/TD]
[TD]N[/TD]
[TD]O[/TD]
[TD]P[/TD]
[TD]Q[/TD]
[TD]R[/TD]
[TD]S[/TD]
[TD]T[/TD]
[TD]U[/TD]
[TD]V[/TD]
[/TR]
[TR]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=cacaca]#cacaca[/URL] , align: center"]1[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=cacaca]#cacaca[/URL] , align: center"]2[/TD]
[TD]Date[/TD]
[TD]Game 1[/TD]
[TD] [/TD]
[TD] [/TD]
[TD]Game 2[/TD]
[TD] [/TD]
[TD] [/TD]
[TD]Game 3[/TD]
[TD] [/TD]
[TD] [/TD]
[TD]Game4[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=b8cce4]#b8cce4[/URL] , align: right"]1[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=b8cce4]#b8cce4[/URL] , align: right"]2[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=b8cce4]#b8cce4[/URL] , align: right"]3[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=b8cce4]#b8cce4[/URL] , align: right"]4[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=b8cce4]#b8cce4[/URL] , align: right"]5[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=b8cce4]#b8cce4[/URL] , align: right"]6[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=b8cce4]#b8cce4[/URL] , align: right"]7[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=b8cce4]#b8cce4[/URL] , align: right"]8[/TD]
[/TR]
[TR]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=cacaca]#cacaca[/URL] , align: center"]3[/TD]
[TD="align: right"]02/07/2019[/TD]
[TD="align: right"]1[/TD]
[TD="align: center"]vs[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]3[/TD]
[TD="align: center"]vs[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]5[/TD]
[TD="align: center"]vs[/TD]
[TD="align: right"]6[/TD]
[TD="align: right"]7[/TD]
[TD="align: center"]vs[/TD]
[TD="align: right"]8[/TD]
[TD] [/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]6[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]8[/TD]
[TD="align: right"]7[/TD]
[/TR]
[TR]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=cacaca]#cacaca[/URL] , align: center"]4[/TD]
[TD="align: right"]2/14/2019[/TD]
[TD="align: right"]6[/TD]
[TD="align: center"]vs[/TD]
[TD="align: right"]8[/TD]
[TD="align: right"]5[/TD]
[TD="align: center"]vs[/TD]
[TD="align: right"]7[/TD]
[TD="align: right"]2[/TD]
[TD="align: center"]vs[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]1[/TD]
[TD="align: center"]vs[/TD]
[TD="align: right"]3[/TD]
[TD] [/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]7[/TD]
[TD="align: right"]8[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]6[/TD]
[/TR]
[TR]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=cacaca]#cacaca[/URL] , align: center"]5[/TD]
[TD="align: right"]2/21/2019[/TD]
[TD="align: right"]5[/TD]
[TD="align: center"]vs[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]1[/TD]
[TD="align: center"]vs[/TD]
[TD="align: right"]8[/TD]
[TD="align: right"]7[/TD]
[TD="align: center"]vs[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]2[/TD]
[TD="align: center"]vs[/TD]
[TD="align: right"]6[/TD]
[TD] [/TD]
[TD="align: right"]8[/TD]
[TD="align: right"]6[/TD]
[TD="align: right"]7[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=cacaca]#cacaca[/URL] , align: center"]6[/TD]
[TD="align: right"]2/28/2019[/TD]
[TD="align: right"]3[/TD]
[TD="align: center"]vs[/TD]
[TD="align: right"]6[/TD]
[TD="align: right"]7[/TD]
[TD="align: center"]vs[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]1[/TD]
[TD="align: center"]vs[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]8[/TD]
[TD="align: center"]vs[/TD]
[TD="align: right"]4[/TD]
[TD] [/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]7[/TD]
[TD="align: right"]6[/TD]
[TD="align: right"]8[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]4[/TD]
[/TR]
[TR]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=cacaca]#cacaca[/URL] , align: center"]7[/TD]
[TD="align: right"]03/07/2019[/TD]
[TD="align: right"]7[/TD]
[TD="align: center"]vs[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]4[/TD]
[TD="align: center"]vs[/TD]
[TD="align: right"]6[/TD]
[TD="align: right"]3[/TD]
[TD="align: center"]vs[/TD]
[TD="align: right"]8[/TD]
[TD="align: right"]5[/TD]
[TD="align: center"]vs[/TD]
[TD="align: right"]2[/TD]
[TD] [/TD]
[TD="align: right"]7[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]8[/TD]
[TD="align: right"]6[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]3[/TD]
[/TR]
[TR]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=cacaca]#cacaca[/URL] , align: center"]8[/TD]
[TD="align: right"]3/14/2019[/TD]
[TD="align: right"]2[/TD]
[TD="align: center"]vs[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]8[/TD]
[TD="align: center"]vs[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]4[/TD]
[TD="align: center"]vs[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]6[/TD]
[TD="align: center"]vs[/TD]
[TD="align: right"]7[/TD]
[TD] [/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]8[/TD]
[TD="align: right"]7[/TD]
[TD="align: right"]6[/TD]
[TD="align: right"]5[/TD]
[/TR]
[TR]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=cacaca]#cacaca[/URL] , align: center"]9[/TD]
[TD="align: right"]3/21/2019[/TD]
[TD="align: right"]4[/TD]
[TD="align: center"]vs[/TD]
[TD="align: right"]7[/TD]
[TD="align: right"]6[/TD]
[TD="align: center"]vs[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]8[/TD]
[TD="align: center"]vs[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]3[/TD]
[TD="align: center"]vs[/TD]
[TD="align: right"]5[/TD]
[TD] [/TD]
[TD="align: right"]6[/TD]
[TD="align: right"]8[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]7[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]2[/TD]
[/TR]
[TR]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=cacaca]#cacaca[/URL] , align: center"]10[/TD]
[TD="align: right"]3/28/2019[/TD]
[TD="align: right"]5[/TD]
[TD="align: center"]vs[/TD]
[TD="align: right"]6[/TD]
[TD="align: right"]7[/TD]
[TD="align: center"]vs[/TD]
[TD="align: right"]8[/TD]
[TD="align: right"]3[/TD]
[TD="align: center"]vs[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]1[/TD]
[TD="align: center"]vs[/TD]
[TD="align: right"]2[/TD]
[TD] [/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]6[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]8[/TD]
[TD="align: right"]7[/TD]
[/TR]
[TR]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=cacaca]#cacaca[/URL] , align: center"]11[/TD]
[TD="align: right"]04/04/2019[/TD]
[TD="align: right"]2[/TD]
[TD="align: center"]vs[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]1[/TD]
[TD="align: center"]vs[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]5[/TD]
[TD="align: center"]vs[/TD]
[TD="align: right"]7[/TD]
[TD="align: right"]6[/TD]
[TD="align: center"]vs[/TD]
[TD="align: right"]8[/TD]
[TD] [/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]7[/TD]
[TD="align: right"]8[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]6[/TD]
[/TR]
[TR]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=cacaca]#cacaca[/URL] , align: center"]12[/TD]
[TD="align: right"]04/11/2019[/TD]
[TD="align: right"]7[/TD]
[TD="align: center"]vs[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]2[/TD]
[TD="align: center"]vs[/TD]
[TD="align: right"]6[/TD]
[TD="align: right"]1[/TD]
[TD="align: center"]vs[/TD]
[TD="align: right"]8[/TD]
[TD="align: right"]5[/TD]
[TD="align: center"]vs[/TD]
[TD="align: right"]4[/TD]
[TD] [/TD]
[TD="align: right"]8[/TD]
[TD="align: right"]6[/TD]
[TD="align: right"]7[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=cacaca]#cacaca[/URL] , align: center"]13[/TD]
[TD="align: right"]4/18/2019[/TD]
[TD="align: right"]1[/TD]
[TD="align: center"]vs[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]8[/TD]
[TD="align: center"]vs[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]7[/TD]
[TD="align: center"]vs[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]3[/TD]
[TD="align: center"]vs[/TD]
[TD="align: right"]6[/TD]
[TD] [/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]7[/TD]
[TD="align: right"]6[/TD]
[TD="align: right"]8[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]4[/TD]
[/TR]
[TR]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=cacaca]#cacaca[/URL] , align: center"]14[/TD]
[TD="align: right"]4/25/2019[/TD]
[TD="align: right"]3[/TD]
[TD="align: center"]vs[/TD]
[TD="align: right"]8[/TD]
[TD="align: right"]5[/TD]
[TD="align: center"]vs[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]4[/TD]
[TD="align: center"]vs[/TD]
[TD="align: right"]6[/TD]
[TD="align: right"]7[/TD]
[TD="align: center"]vs[/TD]
[TD="align: right"]1[/TD]
[TD] [/TD]
[TD="align: right"]7[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]8[/TD]
[TD="align: right"]6[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]3[/TD]
[/TR]
</tbody>[/TABLE]

 

[James Lever]

Try

[TABLE="width: 776"]
<colgroup><col><col><col><col><col><col><col><col><col><col span="3"><col><col span="3"><col><col span="8"></colgroup><tbody>[TR]
[TD]Col A[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Col R[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD="colspan: 8"]All Games[/TD]
[/TR]
[TR]
[TD]Date[/TD]
[TD="colspan: 4"]Game 1[/TD]
[TD="colspan: 4"]Game 2[/TD]
[TD="colspan: 3"]Game 3[/TD]
[TD] [/TD]
[TD="colspan: 3"]Game4[/TD]
[TD] [/TD]
[TD]1[/TD]
[TD]2[/TD]
[TD]3[/TD]
[TD]4[/TD]
[TD]5[/TD]
[TD]6[/TD]
[TD]7[/TD]
[TD]8[/TD]
[/TR]
[TR]
[TD]02/07/2019[/TD]
[TD]1[/TD]
[TD]vs[/TD]
[TD]2[/TD]
[TD] [/TD]
[TD]3[/TD]
[TD]vs[/TD]
[TD]4[/TD]
[TD] [/TD]
[TD]5[/TD]
[TD]vs[/TD]
[TD]6[/TD]
[TD] [/TD]
[TD]7[/TD]
[TD]vs[/TD]
[TD]8[/TD]
[TD] [/TD]
[TD]2[/TD]
[TD]1[/TD]
[TD]4[/TD]
[TD]3[/TD]
[TD]6[/TD]
[TD]5[/TD]
[TD]8[/TD]
[TD]7[/TD]
[/TR]
[TR]
[TD]2/14/2019[/TD]
[TD]6[/TD]
[TD]vs[/TD]
[TD]8[/TD]
[TD] [/TD]
[TD]5[/TD]
[TD]vs[/TD]
[TD]7[/TD]
[TD] [/TD]
[TD]2[/TD]
[TD]vs[/TD]
[TD]4[/TD]
[TD] [/TD]
[TD]1[/TD]
[TD]vs[/TD]
[TD]3[/TD]
[TD] [/TD]
[TD]3[/TD]
[TD]4[/TD]
[TD]1[/TD]
[TD]2[/TD]
[TD]7[/TD]
[TD]8[/TD]
[TD]5[/TD]
[TD]6[/TD]
[/TR]
[TR]
[TD]2/21/2019[/TD]
[TD]5[/TD]
[TD]vs[/TD]
[TD]4[/TD]
[TD] [/TD]
[TD]1[/TD]
[TD]vs[/TD]
[TD]8[/TD]
[TD] [/TD]
[TD]7[/TD]
[TD]vs[/TD]
[TD]3[/TD]
[TD] [/TD]
[TD]2[/TD]
[TD]vs[/TD]
[TD]6[/TD]
[TD] [/TD]
[TD]8[/TD]
[TD]6[/TD]
[TD]7[/TD]
[TD]5[/TD]
[TD]4[/TD]
[TD]2[/TD]
[TD]3[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]2/28/2019[/TD]
[TD]3[/TD]
[TD]vs[/TD]
[TD]6[/TD]
[TD] [/TD]
[TD]7[/TD]
[TD]vs[/TD]
[TD]2[/TD]
[TD] [/TD]
[TD]1[/TD]
[TD]vs[/TD]
[TD]5[/TD]
[TD] [/TD]
[TD]8[/TD]
[TD]vs[/TD]
[TD]4[/TD]
[TD] [/TD]
[TD]5[/TD]
[TD]7[/TD]
[TD]6[/TD]
[TD]8[/TD]
[TD]1[/TD]
[TD]3[/TD]
[TD]2[/TD]
[TD]4[/TD]
[/TR]
[TR]
[TD]03/07/2019[/TD]
[TD]7[/TD]
[TD]vs[/TD]
[TD]1[/TD]
[TD] [/TD]
[TD]4[/TD]
[TD]vs[/TD]
[TD]6[/TD]
[TD] [/TD]
[TD]3[/TD]
[TD]vs[/TD]
[TD]8[/TD]
[TD] [/TD]
[TD]5[/TD]
[TD]vs[/TD]
[TD]2[/TD]
[TD] [/TD]
[TD]7[/TD]
[TD]5[/TD]
[TD]8[/TD]
[TD]6[/TD]
[TD]2[/TD]
[TD]4[/TD]
[TD]1[/TD]
[TD]3[/TD]
[/TR]
[TR]
[TD]3/14/2019[/TD]
[TD]2[/TD]
[TD]vs[/TD]
[TD]3[/TD]
[TD] [/TD]
[TD]8[/TD]
[TD]vs[/TD]
[TD]5[/TD]
[TD] [/TD]
[TD]4[/TD]
[TD]vs[/TD]
[TD]1[/TD]
[TD] [/TD]
[TD]6[/TD]
[TD]vs[/TD]
[TD]7[/TD]
[TD] [/TD]
[TD]4[/TD]
[TD]3[/TD]
[TD]2[/TD]
[TD]1[/TD]
[TD]8[/TD]
[TD]7[/TD]
[TD]6[/TD]
[TD]5[/TD]
[/TR]
[TR]
[TD]3/21/2019[/TD]
[TD]4[/TD]
[TD]vs[/TD]
[TD]7[/TD]
[TD] [/TD]
[TD]6[/TD]
[TD]vs[/TD]
[TD]1[/TD]
[TD] [/TD]
[TD]8[/TD]
[TD]vs[/TD]
[TD]2[/TD]
[TD] [/TD]
[TD]3[/TD]
[TD]vs[/TD]
[TD]5[/TD]
[TD] [/TD]
[TD]6[/TD]
[TD]8[/TD]
[TD]5[/TD]
[TD]7[/TD]
[TD]3[/TD]
[TD]1[/TD]
[TD]4[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]3/28/2019[/TD]
[TD]5[/TD]
[TD]vs[/TD]
[TD]6[/TD]
[TD] [/TD]
[TD]7[/TD]
[TD]vs[/TD]
[TD]8[/TD]
[TD] [/TD]
[TD]3[/TD]
[TD]vs[/TD]
[TD]4[/TD]
[TD] [/TD]
[TD]1[/TD]
[TD]vs[/TD]
[TD]2[/TD]
[TD] [/TD]
[TD]2[/TD]
[TD]1[/TD]
[TD]4[/TD]
[TD]3[/TD]
[TD]6[/TD]
[TD]5[/TD]
[TD]8[/TD]
[TD]7[/TD]
[/TR]
[TR]
[TD]04/04/2019[/TD]
[TD]2[/TD]
[TD]vs[/TD]
[TD]4[/TD]
[TD] [/TD]
[TD]1[/TD]
[TD]vs[/TD]
[TD]3[/TD]
[TD] [/TD]
[TD]5[/TD]
[TD]vs[/TD]
[TD]7[/TD]
[TD] [/TD]
[TD]6[/TD]
[TD]vs[/TD]
[TD]8[/TD]
[TD] [/TD]
[TD]3[/TD]
[TD]4[/TD]
[TD]1[/TD]
[TD]2[/TD]
[TD]7[/TD]
[TD]8[/TD]
[TD]5[/TD]
[TD]6[/TD]
[/TR]
[TR]
[TD]04/11/2019[/TD]
[TD]7[/TD]
[TD]vs[/TD]
[TD]3[/TD]
[TD] [/TD]
[TD]2[/TD]
[TD]vs[/TD]
[TD]6[/TD]
[TD] [/TD]
[TD]1[/TD]
[TD]vs[/TD]
[TD]8[/TD]
[TD] [/TD]
[TD]5[/TD]
[TD]vs[/TD]
[TD]4[/TD]
[TD] [/TD]
[TD]8[/TD]
[TD]6[/TD]
[TD]7[/TD]
[TD]5[/TD]
[TD]4[/TD]
[TD]2[/TD]
[TD]3[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]4/18/2019[/TD]
[TD]1[/TD]
[TD]vs[/TD]
[TD]5[/TD]
[TD] [/TD]
[TD]8[/TD]
[TD]vs[/TD]
[TD]4[/TD]
[TD] [/TD]
[TD]7[/TD]
[TD]vs[/TD]
[TD]2[/TD]
[TD] [/TD]
[TD]3[/TD]
[TD]vs[/TD]
[TD]6[/TD]
[TD] [/TD]
[TD]5[/TD]
[TD]7[/TD]
[TD]6[/TD]
[TD]8[/TD]
[TD]1[/TD]
[TD]3[/TD]
[TD]2[/TD]
[TD]4[/TD]
[/TR]
[TR]
[TD]4/25/2019[/TD]
[TD]3[/TD]
[TD]vs[/TD]
[TD]8[/TD]
[TD] [/TD]
[TD]5[/TD]
[TD]vs[/TD]
[TD]2[/TD]
[TD] [/TD]
[TD]4[/TD]
[TD]vs[/TD]
[TD]6[/TD]
[TD] [/TD]
[TD]7[/TD]
[TD]vs[/TD]
[TD]1[/TD]
[TD] [/TD]
[TD]7[/TD]
[TD]5[/TD]
[TD]8[/TD]
[TD]6[/TD]
[TD]2[/TD]
[TD]4[/TD]
[TD]1[/TD]
[TD]3[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="colspan: 25"]Formula in R4: =IF(INDEX($B4:$Q4,1,MATCH(R$3,$B4:$Q4,0)+1)="vs",INDEX($B4:$Q4,1,MATCH(R$3,$B4:$Q4,0)+2),INDEX($B4:$Q4,1,MATCH(R$3,$B4:$Q4,0)-2))[/TD]
[/TR]
</tbody>[/TABLE]

 

[senechia]

Try

[TABLE="width: 776"]
<tbody>[TR]
[TD]Col A[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Col R[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="colspan: 8"]All Games[/TD]
[/TR]
[TR]
[TD]Date[/TD]
[TD="colspan: 4"]Game 1[/TD]
[TD="colspan: 4"]Game 2[/TD]
[TD="colspan: 3"]Game 3[/TD]
[TD][/TD]
[TD="colspan: 3"]Game4[/TD]
[TD][/TD]
[TD]1[/TD]
[TD]2[/TD]
[TD]3[/TD]
[TD]4[/TD]
[TD]5[/TD]
[TD]6[/TD]
[TD]7[/TD]
[TD]8[/TD]
[/TR]
[TR]
[TD]02/07/2019[/TD]
[TD]1[/TD]
[TD]vs[/TD]
[TD]2[/TD]
[TD][/TD]
[TD]3[/TD]
[TD]vs[/TD]
[TD]4[/TD]
[TD][/TD]
[TD]5[/TD]
[TD]vs[/TD]
[TD]6[/TD]
[TD][/TD]
[TD]7[/TD]
[TD]vs[/TD]
[TD]8[/TD]
[TD][/TD]
[TD]2[/TD]
[TD]1[/TD]
[TD]4[/TD]
[TD]3[/TD]
[TD]6[/TD]
[TD]5[/TD]
[TD]8[/TD]
[TD]7[/TD]
[/TR]
[TR]
[TD]2/14/2019[/TD]
[TD]6[/TD]
[TD]vs[/TD]
[TD]8[/TD]
[TD][/TD]
[TD]5[/TD]
[TD]vs[/TD]
[TD]7[/TD]
[TD][/TD]
[TD]2[/TD]
[TD]vs[/TD]
[TD]4[/TD]
[TD][/TD]
[TD]1[/TD]
[TD]vs[/TD]
[TD]3[/TD]
[TD][/TD]
[TD]3[/TD]
[TD]4[/TD]
[TD]1[/TD]
[TD]2[/TD]
[TD]7[/TD]
[TD]8[/TD]
[TD]5[/TD]
[TD]6[/TD]
[/TR]
[TR]
[TD]2/21/2019[/TD]
[TD]5[/TD]
[TD]vs[/TD]
[TD]4[/TD]
[TD][/TD]
[TD]1[/TD]
[TD]vs[/TD]
[TD]8[/TD]
[TD][/TD]
[TD]7[/TD]
[TD]vs[/TD]
[TD]3[/TD]
[TD][/TD]
[TD]2[/TD]
[TD]vs[/TD]
[TD]6[/TD]
[TD][/TD]
[TD]8[/TD]
[TD]6[/TD]
[TD]7[/TD]
[TD]5[/TD]
[TD]4[/TD]
[TD]2[/TD]
[TD]3[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]2/28/2019[/TD]
[TD]3[/TD]
[TD]vs[/TD]
[TD]6[/TD]
[TD][/TD]
[TD]7[/TD]
[TD]vs[/TD]
[TD]2[/TD]
[TD][/TD]
[TD]1[/TD]
[TD]vs[/TD]
[TD]5[/TD]
[TD][/TD]
[TD]8[/TD]
[TD]vs[/TD]
[TD]4[/TD]
[TD][/TD]
[TD]5[/TD]
[TD]7[/TD]
[TD]6[/TD]
[TD]8[/TD]
[TD]1[/TD]
[TD]3[/TD]
[TD]2[/TD]
[TD]4[/TD]
[/TR]
[TR]
[TD]03/07/2019[/TD]
[TD]7[/TD]
[TD]vs[/TD]
[TD]1[/TD]
[TD][/TD]
[TD]4[/TD]
[TD]vs[/TD]
[TD]6[/TD]
[TD][/TD]
[TD]3[/TD]
[TD]vs[/TD]
[TD]8[/TD]
[TD][/TD]
[TD]5[/TD]
[TD]vs[/TD]
[TD]2[/TD]
[TD][/TD]
[TD]7[/TD]
[TD]5[/TD]
[TD]8[/TD]
[TD]6[/TD]
[TD]2[/TD]
[TD]4[/TD]
[TD]1[/TD]
[TD]3[/TD]
[/TR]
[TR]
[TD]3/14/2019[/TD]
[TD]2[/TD]
[TD]vs[/TD]
[TD]3[/TD]
[TD][/TD]
[TD]8[/TD]
[TD]vs[/TD]
[TD]5[/TD]
[TD][/TD]
[TD]4[/TD]
[TD]vs[/TD]
[TD]1[/TD]
[TD][/TD]
[TD]6[/TD]
[TD]vs[/TD]
[TD]7[/TD]
[TD][/TD]
[TD]4[/TD]
[TD]3[/TD]
[TD]2[/TD]
[TD]1[/TD]
[TD]8[/TD]
[TD]7[/TD]
[TD]6[/TD]
[TD]5[/TD]
[/TR]
[TR]
[TD]3/21/2019[/TD]
[TD]4[/TD]
[TD]vs[/TD]
[TD]7[/TD]
[TD][/TD]
[TD]6[/TD]
[TD]vs[/TD]
[TD]1[/TD]
[TD][/TD]
[TD]8[/TD]
[TD]vs[/TD]
[TD]2[/TD]
[TD][/TD]
[TD]3[/TD]
[TD]vs[/TD]
[TD]5[/TD]
[TD][/TD]
[TD]6[/TD]
[TD]8[/TD]
[TD]5[/TD]
[TD]7[/TD]
[TD]3[/TD]
[TD]1[/TD]
[TD]4[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]3/28/2019[/TD]
[TD]5[/TD]
[TD]vs[/TD]
[TD]6[/TD]
[TD][/TD]
[TD]7[/TD]
[TD]vs[/TD]
[TD]8[/TD]
[TD][/TD]
[TD]3[/TD]
[TD]vs[/TD]
[TD]4[/TD]
[TD][/TD]
[TD]1[/TD]
[TD]vs[/TD]
[TD]2[/TD]
[TD][/TD]
[TD]2[/TD]
[TD]1[/TD]
[TD]4[/TD]
[TD]3[/TD]
[TD]6[/TD]
[TD]5[/TD]
[TD]8[/TD]
[TD]7[/TD]
[/TR]
[TR]
[TD]04/04/2019[/TD]
[TD]2[/TD]
[TD]vs[/TD]
[TD]4[/TD]
[TD][/TD]
[TD]1[/TD]
[TD]vs[/TD]
[TD]3[/TD]
[TD][/TD]
[TD]5[/TD]
[TD]vs[/TD]
[TD]7[/TD]
[TD][/TD]
[TD]6[/TD]
[TD]vs[/TD]
[TD]8[/TD]
[TD][/TD]
[TD]3[/TD]
[TD]4[/TD]
[TD]1[/TD]
[TD]2[/TD]
[TD]7[/TD]
[TD]8[/TD]
[TD]5[/TD]
[TD]6[/TD]
[/TR]
[TR]
[TD]04/11/2019[/TD]
[TD]7[/TD]
[TD]vs[/TD]
[TD]3[/TD]
[TD][/TD]
[TD]2[/TD]
[TD]vs[/TD]
[TD]6[/TD]
[TD][/TD]
[TD]1[/TD]
[TD]vs[/TD]
[TD]8[/TD]
[TD][/TD]
[TD]5[/TD]
[TD]vs[/TD]
[TD]4[/TD]
[TD][/TD]
[TD]8[/TD]
[TD]6[/TD]
[TD]7[/TD]
[TD]5[/TD]
[TD]4[/TD]
[TD]2[/TD]
[TD]3[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]4/18/2019[/TD]
[TD]1[/TD]
[TD]vs[/TD]
[TD]5[/TD]
[TD][/TD]
[TD]8[/TD]
[TD]vs[/TD]
[TD]4[/TD]
[TD][/TD]
[TD]7[/TD]
[TD]vs[/TD]
[TD]2[/TD]
[TD][/TD]
[TD]3[/TD]
[TD]vs[/TD]
[TD]6[/TD]
[TD][/TD]
[TD]5[/TD]
[TD]7[/TD]
[TD]6[/TD]
[TD]8[/TD]
[TD]1[/TD]
[TD]3[/TD]
[TD]2[/TD]
[TD]4[/TD]
[/TR]
[TR]
[TD]4/25/2019[/TD]
[TD]3[/TD]
[TD]vs[/TD]
[TD]8[/TD]
[TD][/TD]
[TD]5[/TD]
[TD]vs[/TD]
[TD]2[/TD]
[TD][/TD]
[TD]4[/TD]
[TD]vs[/TD]
[TD]6[/TD]
[TD][/TD]
[TD]7[/TD]
[TD]vs[/TD]
[TD]1[/TD]
[TD][/TD]
[TD]7[/TD]
[TD]5[/TD]
[TD]8[/TD]
[TD]6[/TD]
[TD]2[/TD]
[TD]4[/TD]
[TD]1[/TD]
[TD]3[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="colspan: 25"]Formula in R4: =IF(INDEX($B4:$Q4,1,MATCH(R$3,$B4:$Q4,0)+1)="vs",INDEX($B4:$Q4,1,MATCH(R$3,$B4:$Q4,0)+2),INDEX($B4:$Q4,1,MATCH(R$3,$B4:$Q4,0)-2))[/TD]
[/TR]
</tbody>[/TABLE]

Thank you both for the help. It is much appreciated.