How can I make a formula to find what team has played Los Angeles Rams in week 1 and 2 and other weeks.
I know you can use the vlookup formula in week 1 and use the vlookup choose in week 2 to see what team Los Angeles Rams played.
I want to be able to make a formula that when I place it in any week it will find who the Los Angeles Rams played.
Much appreciated if anyone can help. Because the Los Angeles Rams will be sometimes in column 1 and sometimes in Column 2 depending on if they are at home or away.
[TABLE="width: 763"]
<colgroup><col><col><col><col><col><col><col><col></colgroup><tbody>[TR]
[TD][/TD]
[TD]team played[/TD]
[TD]team played[/TD]
[TD][/TD]
[TD]Week 1[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]list[/TD]
[TD]week 1[/TD]
[TD]week 2[/TD]
[TD][/TD]
[TD]Team[/TD]
[TD]Score[/TD]
[TD]Team[/TD]
[TD]Score[/TD]
[/TR]
[TR]
[TD]Los Angeles Rams
[/TD]
[TD] _____
[/TD]
[TD] _____
[/TD]
[TD][/TD]
[TD]Atlanta Falcons[/TD]
[TD="align: right"]1[/TD]
[TD]Philadelphia Eagles[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]Kansas City Chiefs[/TD]
[TD]
[/TD]
[TD] [/TD]
[TD][/TD]
[TD]Cincinnati Bengals[/TD]
[TD="align: right"]2[/TD]
[TD]Indianapolis Colts[/TD]
[TD="align: right"]2[/TD]
[/TR]
[TR]
[TD]New Orleans Saints[/TD]
[TD] [/TD]
[TD] [/TD]
[TD][/TD]
[TD]Pittsburgh Steelers[/TD]
[TD="align: right"]3[/TD]
[TD]Cleveland Browns[/TD]
[TD="align: right"]3[/TD]
[/TR]
[TR]
[TD]Los Angeles Chargers[/TD]
[TD] [/TD]
[TD] [/TD]
[TD][/TD]
[TD]Buffalo Bills[/TD]
[TD="align: right"]4[/TD]
[TD]Baltimore Ravens[/TD]
[TD="align: right"]4[/TD]
[/TR]
[TR]
[TD]New England Patriots[/TD]
[TD] [/TD]
[TD] [/TD]
[TD][/TD]
[TD]Jacksonville Jaguars[/TD]
[TD="align: right"]5[/TD]
[TD]New York Giants[/TD]
[TD="align: right"]5[/TD]
[/TR]
[TR]
[TD]Carolina Panthers[/TD]
[TD] [/TD]
[TD] [/TD]
[TD][/TD]
[TD]Houston Texans[/TD]
[TD="align: right"]6[/TD]
[TD]New England Patriots[/TD]
[TD="align: right"]6[/TD]
[/TR]
[TR]
[TD]Houston Texans[/TD]
[TD] [/TD]
[TD] [/TD]
[TD][/TD]
[TD]Tampa Bay Buccaneers[/TD]
[TD="align: right"]7[/TD]
[TD]New Orleans Saints[/TD]
[TD="align: right"]7[/TD]
[/TR]
[TR]
[TD]Washington Redskins[/TD]
[TD] [/TD]
[TD] [/TD]
[TD][/TD]
[TD]San Francisco 49ers[/TD]
[TD="align: right"]8[/TD]
[TD]Minnesota Vikings[/TD]
[TD="align: right"]8[/TD]
[/TR]
[TR]
[TD]Chicago Bears[/TD]
[TD] [/TD]
[TD] [/TD]
[TD][/TD]
[TD]Tennessee Titans[/TD]
[TD="align: right"]9
[/TD]
[TD]Miami Dolphins[/TD]
[TD="align: right"]9[/TD]
[/TR]
[TR]
[TD]Pittsburgh Steelers[/TD]
[TD] [/TD]
[TD] [/TD]
[TD][/TD]
[TD]Kansas City Chiefs[/TD]
[TD="align: right"]10[/TD]
[TD]Los Angeles Chargers[/TD]
[TD="align: right"]10[/TD]
[/TR]
[TR]
[TD]Cincinnati Bengals[/TD]
[TD] [/TD]
[TD] [/TD]
[TD][/TD]
[TD]Seattle Seahawks[/TD]
[TD="align: right"]11[/TD]
[TD]Denver Broncos[/TD]
[TD="align: right"]11[/TD]
[/TR]
[TR]
[TD]Minnesota Vikings[/TD]
[TD] [/TD]
[TD] [/TD]
[TD][/TD]
[TD]Washington Redskins[/TD]
[TD="align: right"]12[/TD]
[TD]Arizona Cardinals[/TD]
[TD="align: right"]12[/TD]
[/TR]
[TR]
[TD]Tennessee Titans[/TD]
[TD] [/TD]
[TD] [/TD]
[TD][/TD]
[TD]Dallas Cowboys[/TD]
[TD="align: right"]13[/TD]
[TD]Carolina Panthers[/TD]
[TD="align: right"]13[/TD]
[/TR]
[TR]
[TD]Miami Dolphins[/TD]
[TD] [/TD]
[TD] [/TD]
[TD][/TD]
[TD]Chicago Bears[/TD]
[TD="align: right"]14[/TD]
[TD]Green Bay Packers[/TD]
[TD="align: right"]14[/TD]
[/TR]
[TR]
[TD]Atlanta Falcons[/TD]
[TD] [/TD]
[TD] [/TD]
[TD][/TD]
[TD]New York Jets[/TD]
[TD="align: right"]15[/TD]
[TD]Detroit Lions[/TD]
[TD="align: right"]15[/TD]
[/TR]
[TR]
[TD]Seattle Seahawks[/TD]
[TD] [/TD]
[TD] [/TD]
[TD][/TD]
[TD]Los Angeles Rams
[/TD]
[TD="align: right"]16[/TD]
[TD]Oakland Raiders[/TD]
[TD="align: right"]16[/TD]
[/TR]
[TR]
[TD]Philadelphia Eagles[/TD]
[TD] [/TD]
[TD] [/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Baltimore Ravens[/TD]
[TD] [/TD]
[TD] [/TD]
[TD][/TD]
[TD]Week 2[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Dallas Cowboys[/TD]
[TD] [/TD]
[TD] [/TD]
[TD][/TD]
[TD]Team[/TD]
[TD]Score[/TD]
[TD]Team[/TD]
[TD]Score[/TD]
[/TR]
[TR]
[TD]Green Bay Packers[/TD]
[TD] [/TD]
[TD] [/TD]
[TD][/TD]
[TD]Baltimore Ravens[/TD]
[TD="align: right"]1[/TD]
[TD]Cincinnati Bengals[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]Indianapolis Colts[/TD]
[TD] [/TD]
[TD] [/TD]
[TD][/TD]
[TD]Carolina Panthers[/TD]
[TD="align: right"]2[/TD]
[TD]Atlanta Falcons[/TD]
[TD="align: right"]2[/TD]
[/TR]
[TR]
[TD]Detroit Lions[/TD]
[TD] [/TD]
[TD] [/TD]
[TD][/TD]
[TD]Indianapolis Colts[/TD]
[TD="align: right"]3[/TD]
[TD]Washington Redskins[/TD]
[TD="align: right"]3[/TD]
[/TR]
[TR]
[TD]Tampa Bay Buccaneers[/TD]
[TD] [/TD]
[TD] [/TD]
[TD][/TD]
[TD]Houston Texans[/TD]
[TD="align: right"]4[/TD]
[TD]Tennessee Titans[/TD]
[TD="align: right"]4[/TD]
[/TR]
[TR]
[TD]Jacksonville Jaguars[/TD]
[TD] [/TD]
[TD] [/TD]
[TD][/TD]
[TD]Philadelphia Eagles[/TD]
[TD="align: right"]5[/TD]
[TD]Tampa Bay Buccaneers[/TD]
[TD="align: right"]5[/TD]
[/TR]
[TR]
[TD]Denver Broncos[/TD]
[TD] [/TD]
[TD] [/TD]
[TD][/TD]
[TD]Kansas City Chiefs[/TD]
[TD="align: right"]6[/TD]
[TD]Pittsburgh Steelers[/TD]
[TD="align: right"]6[/TD]
[/TR]
[TR]
[TD]New York Jets[/TD]
[TD] [/TD]
[TD] [/TD]
[TD][/TD]
[TD]Miami Dolphins[/TD]
[TD="align: right"]7[/TD]
[TD]New York Jets[/TD]
[TD="align: right"]7[/TD]
[/TR]
[TR]
[TD]Buffalo Bills[/TD]
[TD] [/TD]
[TD] [/TD]
[TD][/TD]
[TD]Los Angeles Chargers[/TD]
[TD="align: right"]8[/TD]
[TD]Buffalo Bills[/TD]
[TD="align: right"]8[/TD]
[/TR]
[TR]
[TD]Cleveland Browns[/TD]
[TD] [/TD]
[TD] [/TD]
[TD][/TD]
[TD]Minnesota Vikings[/TD]
[TD="align: right"]9[/TD]
[TD]Green Bay Packers[/TD]
[TD="align: right"]9[/TD]
[/TR]
[TR]
[TD]Arizona Cardinals[/TD]
[TD] [/TD]
[TD] [/TD]
[TD][/TD]
[TD]Cleveland Browns[/TD]
[TD="align: right"]10[/TD]
[TD]New Orleans Saints
[/TD]
[TD="align: right"]10[/TD]
[/TR]
[TR]
[TD]New York Giants[/TD]
[TD] [/TD]
[TD] [/TD]
[TD][/TD]
[TD]Detroit Lions[/TD]
[TD="align: right"]11[/TD]
[TD]San Francisco 49ers[/TD]
[TD="align: right"]11[/TD]
[/TR]
[TR]
[TD]San Francisco 49ers[/TD]
[TD] [/TD]
[TD] [/TD]
[TD][/TD]
[TD]Arizona Cardinals[/TD]
[TD="align: right"]12[/TD]
[TD]Los Angeles Rams
[/TD]
[TD="align: right"]12[/TD]
[/TR]
[TR]
[TD]Oakland Raiders[/TD]
[TD] [/TD]
[TD] [/TD]
[TD][/TD]
[TD]New England Patriots[/TD]
[TD="align: right"]13[/TD]
[TD]Jacksonville Jaguars[/TD]
[TD="align: right"]13[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Oakland Raiders[/TD]
[TD="align: right"]14[/TD]
[TD]Denver Broncos[/TD]
[TD="align: right"]14[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]New York Giants[/TD]
[TD="align: right"]15[/TD]
[TD]Dallas Cowboys[/TD]
[TD="align: right"]15[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Seattle Seahawks[/TD]
[TD="align: right"]16[/TD]
[TD]Chicago Bears[/TD]
[TD="align: right"]16[/TD]
[/TR]
</tbody>[/TABLE]
I know you can use the vlookup formula in week 1 and use the vlookup choose in week 2 to see what team Los Angeles Rams played.
I want to be able to make a formula that when I place it in any week it will find who the Los Angeles Rams played.
Much appreciated if anyone can help. Because the Los Angeles Rams will be sometimes in column 1 and sometimes in Column 2 depending on if they are at home or away.
[TABLE="width: 763"]
<colgroup><col><col><col><col><col><col><col><col></colgroup><tbody>[TR]
[TD][/TD]
[TD]team played[/TD]
[TD]team played[/TD]
[TD][/TD]
[TD]Week 1[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]list[/TD]
[TD]week 1[/TD]
[TD]week 2[/TD]
[TD][/TD]
[TD]Team[/TD]
[TD]Score[/TD]
[TD]Team[/TD]
[TD]Score[/TD]
[/TR]
[TR]
[TD]Los Angeles Rams
[/TD]
[TD] _____
[/TD]
[TD] _____
[/TD]
[TD][/TD]
[TD]Atlanta Falcons[/TD]
[TD="align: right"]1[/TD]
[TD]Philadelphia Eagles[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]Kansas City Chiefs[/TD]
[TD]
[/TD]
[TD] [/TD]
[TD][/TD]
[TD]Cincinnati Bengals[/TD]
[TD="align: right"]2[/TD]
[TD]Indianapolis Colts[/TD]
[TD="align: right"]2[/TD]
[/TR]
[TR]
[TD]New Orleans Saints[/TD]
[TD] [/TD]
[TD] [/TD]
[TD][/TD]
[TD]Pittsburgh Steelers[/TD]
[TD="align: right"]3[/TD]
[TD]Cleveland Browns[/TD]
[TD="align: right"]3[/TD]
[/TR]
[TR]
[TD]Los Angeles Chargers[/TD]
[TD] [/TD]
[TD] [/TD]
[TD][/TD]
[TD]Buffalo Bills[/TD]
[TD="align: right"]4[/TD]
[TD]Baltimore Ravens[/TD]
[TD="align: right"]4[/TD]
[/TR]
[TR]
[TD]New England Patriots[/TD]
[TD] [/TD]
[TD] [/TD]
[TD][/TD]
[TD]Jacksonville Jaguars[/TD]
[TD="align: right"]5[/TD]
[TD]New York Giants[/TD]
[TD="align: right"]5[/TD]
[/TR]
[TR]
[TD]Carolina Panthers[/TD]
[TD] [/TD]
[TD] [/TD]
[TD][/TD]
[TD]Houston Texans[/TD]
[TD="align: right"]6[/TD]
[TD]New England Patriots[/TD]
[TD="align: right"]6[/TD]
[/TR]
[TR]
[TD]Houston Texans[/TD]
[TD] [/TD]
[TD] [/TD]
[TD][/TD]
[TD]Tampa Bay Buccaneers[/TD]
[TD="align: right"]7[/TD]
[TD]New Orleans Saints[/TD]
[TD="align: right"]7[/TD]
[/TR]
[TR]
[TD]Washington Redskins[/TD]
[TD] [/TD]
[TD] [/TD]
[TD][/TD]
[TD]San Francisco 49ers[/TD]
[TD="align: right"]8[/TD]
[TD]Minnesota Vikings[/TD]
[TD="align: right"]8[/TD]
[/TR]
[TR]
[TD]Chicago Bears[/TD]
[TD] [/TD]
[TD] [/TD]
[TD][/TD]
[TD]Tennessee Titans[/TD]
[TD="align: right"]9
[/TD]
[TD]Miami Dolphins[/TD]
[TD="align: right"]9[/TD]
[/TR]
[TR]
[TD]Pittsburgh Steelers[/TD]
[TD] [/TD]
[TD] [/TD]
[TD][/TD]
[TD]Kansas City Chiefs[/TD]
[TD="align: right"]10[/TD]
[TD]Los Angeles Chargers[/TD]
[TD="align: right"]10[/TD]
[/TR]
[TR]
[TD]Cincinnati Bengals[/TD]
[TD] [/TD]
[TD] [/TD]
[TD][/TD]
[TD]Seattle Seahawks[/TD]
[TD="align: right"]11[/TD]
[TD]Denver Broncos[/TD]
[TD="align: right"]11[/TD]
[/TR]
[TR]
[TD]Minnesota Vikings[/TD]
[TD] [/TD]
[TD] [/TD]
[TD][/TD]
[TD]Washington Redskins[/TD]
[TD="align: right"]12[/TD]
[TD]Arizona Cardinals[/TD]
[TD="align: right"]12[/TD]
[/TR]
[TR]
[TD]Tennessee Titans[/TD]
[TD] [/TD]
[TD] [/TD]
[TD][/TD]
[TD]Dallas Cowboys[/TD]
[TD="align: right"]13[/TD]
[TD]Carolina Panthers[/TD]
[TD="align: right"]13[/TD]
[/TR]
[TR]
[TD]Miami Dolphins[/TD]
[TD] [/TD]
[TD] [/TD]
[TD][/TD]
[TD]Chicago Bears[/TD]
[TD="align: right"]14[/TD]
[TD]Green Bay Packers[/TD]
[TD="align: right"]14[/TD]
[/TR]
[TR]
[TD]Atlanta Falcons[/TD]
[TD] [/TD]
[TD] [/TD]
[TD][/TD]
[TD]New York Jets[/TD]
[TD="align: right"]15[/TD]
[TD]Detroit Lions[/TD]
[TD="align: right"]15[/TD]
[/TR]
[TR]
[TD]Seattle Seahawks[/TD]
[TD] [/TD]
[TD] [/TD]
[TD][/TD]
[TD]Los Angeles Rams
[/TD]
[TD="align: right"]16[/TD]
[TD]Oakland Raiders[/TD]
[TD="align: right"]16[/TD]
[/TR]
[TR]
[TD]Philadelphia Eagles[/TD]
[TD] [/TD]
[TD] [/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Baltimore Ravens[/TD]
[TD] [/TD]
[TD] [/TD]
[TD][/TD]
[TD]Week 2[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Dallas Cowboys[/TD]
[TD] [/TD]
[TD] [/TD]
[TD][/TD]
[TD]Team[/TD]
[TD]Score[/TD]
[TD]Team[/TD]
[TD]Score[/TD]
[/TR]
[TR]
[TD]Green Bay Packers[/TD]
[TD] [/TD]
[TD] [/TD]
[TD][/TD]
[TD]Baltimore Ravens[/TD]
[TD="align: right"]1[/TD]
[TD]Cincinnati Bengals[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]Indianapolis Colts[/TD]
[TD] [/TD]
[TD] [/TD]
[TD][/TD]
[TD]Carolina Panthers[/TD]
[TD="align: right"]2[/TD]
[TD]Atlanta Falcons[/TD]
[TD="align: right"]2[/TD]
[/TR]
[TR]
[TD]Detroit Lions[/TD]
[TD] [/TD]
[TD] [/TD]
[TD][/TD]
[TD]Indianapolis Colts[/TD]
[TD="align: right"]3[/TD]
[TD]Washington Redskins[/TD]
[TD="align: right"]3[/TD]
[/TR]
[TR]
[TD]Tampa Bay Buccaneers[/TD]
[TD] [/TD]
[TD] [/TD]
[TD][/TD]
[TD]Houston Texans[/TD]
[TD="align: right"]4[/TD]
[TD]Tennessee Titans[/TD]
[TD="align: right"]4[/TD]
[/TR]
[TR]
[TD]Jacksonville Jaguars[/TD]
[TD] [/TD]
[TD] [/TD]
[TD][/TD]
[TD]Philadelphia Eagles[/TD]
[TD="align: right"]5[/TD]
[TD]Tampa Bay Buccaneers[/TD]
[TD="align: right"]5[/TD]
[/TR]
[TR]
[TD]Denver Broncos[/TD]
[TD] [/TD]
[TD] [/TD]
[TD][/TD]
[TD]Kansas City Chiefs[/TD]
[TD="align: right"]6[/TD]
[TD]Pittsburgh Steelers[/TD]
[TD="align: right"]6[/TD]
[/TR]
[TR]
[TD]New York Jets[/TD]
[TD] [/TD]
[TD] [/TD]
[TD][/TD]
[TD]Miami Dolphins[/TD]
[TD="align: right"]7[/TD]
[TD]New York Jets[/TD]
[TD="align: right"]7[/TD]
[/TR]
[TR]
[TD]Buffalo Bills[/TD]
[TD] [/TD]
[TD] [/TD]
[TD][/TD]
[TD]Los Angeles Chargers[/TD]
[TD="align: right"]8[/TD]
[TD]Buffalo Bills[/TD]
[TD="align: right"]8[/TD]
[/TR]
[TR]
[TD]Cleveland Browns[/TD]
[TD] [/TD]
[TD] [/TD]
[TD][/TD]
[TD]Minnesota Vikings[/TD]
[TD="align: right"]9[/TD]
[TD]Green Bay Packers[/TD]
[TD="align: right"]9[/TD]
[/TR]
[TR]
[TD]Arizona Cardinals[/TD]
[TD] [/TD]
[TD] [/TD]
[TD][/TD]
[TD]Cleveland Browns[/TD]
[TD="align: right"]10[/TD]
[TD]New Orleans Saints
[/TD]
[TD="align: right"]10[/TD]
[/TR]
[TR]
[TD]New York Giants[/TD]
[TD] [/TD]
[TD] [/TD]
[TD][/TD]
[TD]Detroit Lions[/TD]
[TD="align: right"]11[/TD]
[TD]San Francisco 49ers[/TD]
[TD="align: right"]11[/TD]
[/TR]
[TR]
[TD]San Francisco 49ers[/TD]
[TD] [/TD]
[TD] [/TD]
[TD][/TD]
[TD]Arizona Cardinals[/TD]
[TD="align: right"]12[/TD]
[TD]Los Angeles Rams
[/TD]
[TD="align: right"]12[/TD]
[/TR]
[TR]
[TD]Oakland Raiders[/TD]
[TD] [/TD]
[TD] [/TD]
[TD][/TD]
[TD]New England Patriots[/TD]
[TD="align: right"]13[/TD]
[TD]Jacksonville Jaguars[/TD]
[TD="align: right"]13[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Oakland Raiders[/TD]
[TD="align: right"]14[/TD]
[TD]Denver Broncos[/TD]
[TD="align: right"]14[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]New York Giants[/TD]
[TD="align: right"]15[/TD]
[TD]Dallas Cowboys[/TD]
[TD="align: right"]15[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Seattle Seahawks[/TD]
[TD="align: right"]16[/TD]
[TD]Chicago Bears[/TD]
[TD="align: right"]16[/TD]
[/TR]
</tbody>[/TABLE]