I'm trying to setup a roster. In Cell K1 I have the date (which changes through drop down box). In column A I have a list of dates which some are the same date, Column C has Team 1 and Column E has Team 2
What I'm needing is when I change the date in Cell K1 it only shows Team A on that date in Cell K2 and Team 2 in Cell L2.
[TABLE="width: 479"]
<colgroup><col><col><col><col><col></colgroup><tbody>[TR]
[TD]Tue, Oct 22, 2019[/TD]
[TD]8:00p[/TD]
[TD]New Orleans Pelicans[/TD]
[TD][/TD]
[TD]Toronto Raptors[/TD]
[/TR]
[TR]
[TD]Tue, Oct 22, 2019[/TD]
[TD]10:30p[/TD]
[TD]Los Angeles Lakers[/TD]
[TD][/TD]
[TD]Los Angeles Clippers[/TD]
[/TR]
[TR]
[TD]Wed, Oct 23, 2019[/TD]
[TD]7:00p[/TD]
[TD]Cleveland Cavaliers[/TD]
[TD][/TD]
[TD]Orlando Magic[/TD]
[/TR]
[TR]
[TD]Wed, Oct 23, 2019[/TD]
[TD]7:00p[/TD]
[TD]Detroit Pistons[/TD]
[TD][/TD]
[TD]Indiana Pacers[/TD]
[/TR]
[TR]
[TD]Wed, Oct 23, 2019[/TD]
[TD]7:00p[/TD]
[TD]Chicago Bulls[/TD]
[TD][/TD]
[TD]Charlotte Hornets[/TD]
[/TR]
[TR]
[TD]Wed, Oct 23, 2019[/TD]
[TD]7:30p[/TD]
[TD]Memphis Grizzlies[/TD]
[TD][/TD]
[TD]Miami Heat[/TD]
[/TR]
[TR]
[TD]Wed, Oct 23, 2019[/TD]
[TD]7:30p[/TD]
[TD]Minnesota Timberwolves[/TD]
[TD][/TD]
[TD]Brooklyn Nets[/TD]
[/TR]
[TR]
[TD]Wed, Oct 23, 2019[/TD]
[TD]7:30p[/TD]
[TD]Boston Celtics[/TD]
[TD][/TD]
[TD]Philadelphia 76ers[/TD]
[/TR]
[TR]
[TD]Wed, Oct 23, 2019[/TD]
[TD]8:30p[/TD]
[TD]Washington Wizards[/TD]
[TD][/TD]
[TD]Dallas Mavericks[/TD]
[/TR]
[TR]
[TD]Wed, Oct 23, 2019[/TD]
[TD]8:30p[/TD]
[TD]New York Knicks[/TD]
[TD][/TD]
[TD]San Antonio Spurs[/TD]
[/TR]
[TR]
[TD]Wed, Oct 23, 2019[/TD]
[TD]9:00p[/TD]
[TD]Oklahoma City Thunder[/TD]
[TD][/TD]
[TD]Utah Jazz[/TD]
[/TR]
[TR]
[TD]Wed, Oct 23, 2019[/TD]
[TD]10:00p[/TD]
[TD]Denver Nuggets[/TD]
[TD][/TD]
[TD]Portland Trail Blazers[/TD]
[/TR]
[TR]
[TD]Wed, Oct 23, 2019[/TD]
[TD]10:00p[/TD]
[TD]Sacramento Kings[/TD]
[TD][/TD]
[TD]Phoenix Suns[/TD]
[/TR]
[TR]
[TD]Thu, Oct 24, 2019[/TD]
[TD]7:00p[/TD]
[TD]Atlanta Hawks[/TD]
[TD][/TD]
[TD]Detroit Pistons[/TD]
[/TR]
[TR]
[TD]Thu, Oct 24, 2019[/TD]
[TD]8:00p[/TD]
[TD]Milwaukee Bucks[/TD]
[TD][/TD]
[TD]Houston Rockets[/TD]
[/TR]
[TR]
[TD]Thu, Oct 24, 2019[/TD]
[TD]10:30p[/TD]
[TD]Los Angeles Clippers[/TD]
[TD][/TD]
[TD]Golden State Warriors[/TD]
[/TR]
[TR]
[TD]Fri, Oct 25, 2019[/TD]
[TD]7:00p[/TD]
[TD]Toronto Raptors[/TD]
[TD][/TD]
[TD]Boston Celtics[/TD]
[/TR]
[TR]
[TD]Fri, Oct 25, 2019[/TD]
[TD]7:00p[/TD]
[TD]Minnesota Timberwolves[/TD]
[TD][/TD]
[TD]Charlotte Hornets[/TD]
[/TR]
[TR]
[TD]Fri, Oct 25, 2019[/TD]
[TD]7:30p[/TD]
[TD]New York Knicks[/TD]
[TD][/TD]
[TD]Brooklyn Nets[/TD]
[/TR]
[TR]
[TD]Fri, Oct 25, 2019[/TD]
[TD]8:00p[/TD]
[TD]Washington Wizards[/TD]
[TD][/TD]
[TD]Oklahoma City Thunder[/TD]
[/TR]
[TR]
[TD]Fri, Oct 25, 2019[/TD]
[TD]8:00p[/TD]
[TD]Dallas Mavericks[/TD]
[TD][/TD]
[TD]New Orleans Pelicans[/TD]
[/TR]
[TR]
[TD]Fri, Oct 25, 2019[/TD]
[TD]8:00p[/TD]
[TD]Chicago Bulls[/TD]
[TD][/TD]
[TD]Memphis Grizzlies[/TD]
[/TR]
[TR]
[TD]Fri, Oct 25, 2019[/TD]
[TD]9:00p[/TD]
[TD]Phoenix Suns[/TD]
[TD][/TD]
[TD]Denver Nuggets[/TD]
[/TR]
[TR]
[TD]Fri, Oct 25, 2019[/TD]
[TD]10:00p[/TD]
[TD]Portland Trail Blazers[/TD]
[TD][/TD]
[TD]Sacramento Kings[/TD]
[/TR]
[TR]
[TD]Fri, Oct 25, 2019[/TD]
[TD]10:30p[/TD]
[TD]Utah Jazz[/TD]
[TD][/TD]
[TD]Los Angeles Lakers[/TD]
[/TR]
[TR]
[TD]Sat, Oct 26, 2019[/TD]
[TD]5:00p[/TD]
[TD]Miami Heat[/TD]
[TD][/TD]
[TD]Milwaukee Bucks[/TD]
[/TR]
[TR]
[TD]Sat, Oct 26, 2019[/TD]
[TD]7:00p[/TD]
[TD]Philadelphia 76ers[/TD]
[TD][/TD]
[TD]Detroit Pistons[/TD]
[/TR]
[TR]
[TD]Sat, Oct 26, 2019[/TD]
[TD]7:30p[/TD]
[TD]Orlando Magic[/TD]
[TD][/TD]
[TD]Atlanta Hawks[/TD]
[/TR]
[TR]
[TD]Sat, Oct 26, 2019[/TD]
[TD]7:30p[/TD]
[TD]Boston Celtics[/TD]
[TD][/TD]
[TD]New York Knicks[/TD]
[/TR]
[TR]
[TD]Sat, Oct 26, 2019[/TD]
[TD]8:00p[/TD]
[TD]New Orleans Pelicans[/TD]
[TD][/TD]
[TD]Houston Rockets[/TD]
[/TR]
[TR]
[TD]Sat, Oct 26, 2019[/TD]
[TD]8:00p[/TD]
[TD]Indiana Pacers[/TD]
[TD][/TD]
[TD]Cleveland Cavaliers[/TD]
[/TR]
[TR]
[TD]Sat, Oct 26, 2019[/TD]
[TD]8:00p[/TD]
[TD]Toronto Raptors[/TD]
[TD][/TD]
[TD]Chicago Bulls[/TD]
[/TR]
[TR]
[TD]Sat, Oct 26, 2019[/TD]
[TD]8:30p[/TD]
[TD]Washington Wizards[/TD]
[TD][/TD]
[TD]San Antonio Spurs[/TD]
[/TR]
[TR]
[TD]Sat, Oct 26, 2019[/TD]
[TD]9:00p[/TD]
[TD]Sacramento Kings[/TD]
[TD][/TD]
[TD]Utah Jazz[/TD]
[/TR]
[TR]
[TD]Sat, Oct 26, 2019[/TD]
[TD]10:00p[/TD]
[TD]Los Angeles Clippers[/TD]
[TD][/TD]
[TD]Phoenix Suns[/TD]
[/TR]
</tbody>[/TABLE]
What I'm needing is when I change the date in Cell K1 it only shows Team A on that date in Cell K2 and Team 2 in Cell L2.
[TABLE="width: 479"]
<colgroup><col><col><col><col><col></colgroup><tbody>[TR]
[TD]Tue, Oct 22, 2019[/TD]
[TD]8:00p[/TD]
[TD]New Orleans Pelicans[/TD]
[TD][/TD]
[TD]Toronto Raptors[/TD]
[/TR]
[TR]
[TD]Tue, Oct 22, 2019[/TD]
[TD]10:30p[/TD]
[TD]Los Angeles Lakers[/TD]
[TD][/TD]
[TD]Los Angeles Clippers[/TD]
[/TR]
[TR]
[TD]Wed, Oct 23, 2019[/TD]
[TD]7:00p[/TD]
[TD]Cleveland Cavaliers[/TD]
[TD][/TD]
[TD]Orlando Magic[/TD]
[/TR]
[TR]
[TD]Wed, Oct 23, 2019[/TD]
[TD]7:00p[/TD]
[TD]Detroit Pistons[/TD]
[TD][/TD]
[TD]Indiana Pacers[/TD]
[/TR]
[TR]
[TD]Wed, Oct 23, 2019[/TD]
[TD]7:00p[/TD]
[TD]Chicago Bulls[/TD]
[TD][/TD]
[TD]Charlotte Hornets[/TD]
[/TR]
[TR]
[TD]Wed, Oct 23, 2019[/TD]
[TD]7:30p[/TD]
[TD]Memphis Grizzlies[/TD]
[TD][/TD]
[TD]Miami Heat[/TD]
[/TR]
[TR]
[TD]Wed, Oct 23, 2019[/TD]
[TD]7:30p[/TD]
[TD]Minnesota Timberwolves[/TD]
[TD][/TD]
[TD]Brooklyn Nets[/TD]
[/TR]
[TR]
[TD]Wed, Oct 23, 2019[/TD]
[TD]7:30p[/TD]
[TD]Boston Celtics[/TD]
[TD][/TD]
[TD]Philadelphia 76ers[/TD]
[/TR]
[TR]
[TD]Wed, Oct 23, 2019[/TD]
[TD]8:30p[/TD]
[TD]Washington Wizards[/TD]
[TD][/TD]
[TD]Dallas Mavericks[/TD]
[/TR]
[TR]
[TD]Wed, Oct 23, 2019[/TD]
[TD]8:30p[/TD]
[TD]New York Knicks[/TD]
[TD][/TD]
[TD]San Antonio Spurs[/TD]
[/TR]
[TR]
[TD]Wed, Oct 23, 2019[/TD]
[TD]9:00p[/TD]
[TD]Oklahoma City Thunder[/TD]
[TD][/TD]
[TD]Utah Jazz[/TD]
[/TR]
[TR]
[TD]Wed, Oct 23, 2019[/TD]
[TD]10:00p[/TD]
[TD]Denver Nuggets[/TD]
[TD][/TD]
[TD]Portland Trail Blazers[/TD]
[/TR]
[TR]
[TD]Wed, Oct 23, 2019[/TD]
[TD]10:00p[/TD]
[TD]Sacramento Kings[/TD]
[TD][/TD]
[TD]Phoenix Suns[/TD]
[/TR]
[TR]
[TD]Thu, Oct 24, 2019[/TD]
[TD]7:00p[/TD]
[TD]Atlanta Hawks[/TD]
[TD][/TD]
[TD]Detroit Pistons[/TD]
[/TR]
[TR]
[TD]Thu, Oct 24, 2019[/TD]
[TD]8:00p[/TD]
[TD]Milwaukee Bucks[/TD]
[TD][/TD]
[TD]Houston Rockets[/TD]
[/TR]
[TR]
[TD]Thu, Oct 24, 2019[/TD]
[TD]10:30p[/TD]
[TD]Los Angeles Clippers[/TD]
[TD][/TD]
[TD]Golden State Warriors[/TD]
[/TR]
[TR]
[TD]Fri, Oct 25, 2019[/TD]
[TD]7:00p[/TD]
[TD]Toronto Raptors[/TD]
[TD][/TD]
[TD]Boston Celtics[/TD]
[/TR]
[TR]
[TD]Fri, Oct 25, 2019[/TD]
[TD]7:00p[/TD]
[TD]Minnesota Timberwolves[/TD]
[TD][/TD]
[TD]Charlotte Hornets[/TD]
[/TR]
[TR]
[TD]Fri, Oct 25, 2019[/TD]
[TD]7:30p[/TD]
[TD]New York Knicks[/TD]
[TD][/TD]
[TD]Brooklyn Nets[/TD]
[/TR]
[TR]
[TD]Fri, Oct 25, 2019[/TD]
[TD]8:00p[/TD]
[TD]Washington Wizards[/TD]
[TD][/TD]
[TD]Oklahoma City Thunder[/TD]
[/TR]
[TR]
[TD]Fri, Oct 25, 2019[/TD]
[TD]8:00p[/TD]
[TD]Dallas Mavericks[/TD]
[TD][/TD]
[TD]New Orleans Pelicans[/TD]
[/TR]
[TR]
[TD]Fri, Oct 25, 2019[/TD]
[TD]8:00p[/TD]
[TD]Chicago Bulls[/TD]
[TD][/TD]
[TD]Memphis Grizzlies[/TD]
[/TR]
[TR]
[TD]Fri, Oct 25, 2019[/TD]
[TD]9:00p[/TD]
[TD]Phoenix Suns[/TD]
[TD][/TD]
[TD]Denver Nuggets[/TD]
[/TR]
[TR]
[TD]Fri, Oct 25, 2019[/TD]
[TD]10:00p[/TD]
[TD]Portland Trail Blazers[/TD]
[TD][/TD]
[TD]Sacramento Kings[/TD]
[/TR]
[TR]
[TD]Fri, Oct 25, 2019[/TD]
[TD]10:30p[/TD]
[TD]Utah Jazz[/TD]
[TD][/TD]
[TD]Los Angeles Lakers[/TD]
[/TR]
[TR]
[TD]Sat, Oct 26, 2019[/TD]
[TD]5:00p[/TD]
[TD]Miami Heat[/TD]
[TD][/TD]
[TD]Milwaukee Bucks[/TD]
[/TR]
[TR]
[TD]Sat, Oct 26, 2019[/TD]
[TD]7:00p[/TD]
[TD]Philadelphia 76ers[/TD]
[TD][/TD]
[TD]Detroit Pistons[/TD]
[/TR]
[TR]
[TD]Sat, Oct 26, 2019[/TD]
[TD]7:30p[/TD]
[TD]Orlando Magic[/TD]
[TD][/TD]
[TD]Atlanta Hawks[/TD]
[/TR]
[TR]
[TD]Sat, Oct 26, 2019[/TD]
[TD]7:30p[/TD]
[TD]Boston Celtics[/TD]
[TD][/TD]
[TD]New York Knicks[/TD]
[/TR]
[TR]
[TD]Sat, Oct 26, 2019[/TD]
[TD]8:00p[/TD]
[TD]New Orleans Pelicans[/TD]
[TD][/TD]
[TD]Houston Rockets[/TD]
[/TR]
[TR]
[TD]Sat, Oct 26, 2019[/TD]
[TD]8:00p[/TD]
[TD]Indiana Pacers[/TD]
[TD][/TD]
[TD]Cleveland Cavaliers[/TD]
[/TR]
[TR]
[TD]Sat, Oct 26, 2019[/TD]
[TD]8:00p[/TD]
[TD]Toronto Raptors[/TD]
[TD][/TD]
[TD]Chicago Bulls[/TD]
[/TR]
[TR]
[TD]Sat, Oct 26, 2019[/TD]
[TD]8:30p[/TD]
[TD]Washington Wizards[/TD]
[TD][/TD]
[TD]San Antonio Spurs[/TD]
[/TR]
[TR]
[TD]Sat, Oct 26, 2019[/TD]
[TD]9:00p[/TD]
[TD]Sacramento Kings[/TD]
[TD][/TD]
[TD]Utah Jazz[/TD]
[/TR]
[TR]
[TD]Sat, Oct 26, 2019[/TD]
[TD]10:00p[/TD]
[TD]Los Angeles Clippers[/TD]
[TD][/TD]
[TD]Phoenix Suns[/TD]
[/TR]
</tbody>[/TABLE]