vlookup to see if 2 teams have played each other in different columns

[LAexcel1]

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]

 

[ali zaib]

Can you share excel file to more clarification

 

[ali zaib]

Some thing like that ???

=IFERROR(VLOOKUP($A$3,$E$2:$E$45,1,0),VLOOKUP($A$3,$G$2:$H$45,1,0))

 

[LAexcel1]

Thank you ali zaib.

I did this formula =IFERROR(VLOOKUP(B3,$F$3:$H$18,3,0),VLOOKUP(B3,CHOOSE({1,2,3},$H$3:$H$18,G3:$G$18,$F$3:$F$18),3,0))
I got it to work. I just needed someone to push me a little.
my question how do I finish the IFERROR if I don't want it to say anything. like
when I type this
=IFERROR(VLOOKUP(B3,$F$3:$H$18,3,0),VLOOKUP(B3,CHOOSE({1,2,3},$H$3:$H$18,G3:$G$18,$F$3:$F$18),3,0)),"")))
I get a error message.