Spreadsheet: 639136d1566978452-i-would-like-a-formula-to-get-the-teams-opponents-for-each-week-samplefile-gk-
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Teams
 |  |  |  |  |  |  | Team | NYJ |  |  |  |  |  |  |  |  | KC
Week | V Team | H Team | V Score | H Score | Byes |  | BYES |  |  |  |  |  |  |  |  |  | NYJ
1 | KC | NE | 42 | 27 | TB |  | Week | OPP | PF | PA | TPF | TPA |  |  |  |  | PHI
1 | NYJ | BUF | 12 | 21 | MIA |  | 1 |  |  |  |  |  |  |  |  |  | OAK
1 | PHI | WAS | 30 | 17 |  |  | 2 |  |  |  |  |  |  |  |  |  | JAX
1 | OAK | TEN | 26 | 16 |  |  | 3 |  |  |  |  |  |  |  |  |  | ARI
1 | JAX | HOU | 29 | 7 |  |  | 4 |  |  |  |  |  |  |  |  |  | ATL
1 | ARI | DET | 23 | 35 |  |  | 5 |  |  |  |  |  |  |  |  |  | BAL
1 | ATL | CHI | 23 | 17 |  |  | 6 |  |  |  |  |  |  |  |  |  | PIT
1 | BAL | CIN | 20 | 0 |  |  | 7 |  |  |  |  |  |  |  |  |  | IND
1 | PIT | CLE | 21 | 18 |  |  | 8 |  |  |  |  |  |  |  |  |  | SEA
1 | IND | LAR | 9 | 46 |  |  | 9 |  |  |  |  |  |  |  |  |  | CAR
1 | SEA | GB | 9 | 17 |  |  | 10 |  |  |  |  |  |  |  |  |  | NYG
1 | CAR | SF | 23 | 3 |  |  | 11 |  |  |  |  |  |  |  |  |  | NO
1 | NYG | DAL | 3 | 19 |  |  | 12 |  |  |  |  |  |  |  |  |  | LAC
1 | NO | MIN | 19 | 29 |  |  | 13 |  |  |  |  |  |  |  |  |  | HOU
1 | LAC | DEN | 21 | 24 |  |  | 14 |  |  |  |  |  |  |  |  |  | CLE
2 | HOU | CIN | 13 | 9 |  |  | 15 |  |  |  |  |  |  |  |  |  | CHI
2 | CLE | BAL | 10 | 24 |  |  | 16 |  |  |  |  |  |  |  |  |  | MIN
2 | CHI | TB | 7 | 29 |  |  | 17 |  |  |  |  |  |  |  |  |  | NE
2 | MIN | PIT | 9 | 26 |  |  | TOTALS |  |  |  |  |  |  |  |  |  | TEN
2 | NE | NO | 36 | 20 |  |  |  |  |  |  |  |  |  |  |  |  | BUF
2 | PHI | KC | 20 | 27 |  |  |  |  |  |  |  |  |  |  |  |  | MIA
2 | TEN | JAX | 37 | 16 |  |  |  |  |  |  |  |  |  |  |  |  | SF
2 | ARI | IND | 16 | 13 |  |  |  |  |  |  |  |  |  |  |  |  | WAS
2 | BUF | CAR | 3 | 9 |  |  |  |  |  |  |  |  |  |  |  |  | DAL
2 | NYJ | OAK | 20 | 45 |  |  |  |  |  |  |  |  |  |  |  |  | GB
2 | MIA | LAC | 19 | 17 |  |  |  |  |  |  |  |  |  |  |  |  | DET
2 | SF | SEA | 9 | 12 |  |  |  |  |  |  |  |  |  |  |  |  | LAR
2 | WAS | LAR | 27 | 20 |  |  |  |  |  |  |  |  |  |  |  |  | DEN
2 | DAL | DEN | 17 | 42 |  |  |  |  |  |  |  |  |  |  |  |  | TB
2 | GB | ATL | 23 | 34 |  |  |  |  |  |  |  |  |  |  |  |  | CIN
2 | DET | NYG | 24 | 10
3 | LAR | SF | 41 | 39
3 | BAL | JAX | 7 | 44
3 | CLE | IND | 28 | 31
3 | NYG | PHI | 24 | 27
3 | MIA | NYJ | 6 | 20
3 | DEN | BUF | 16 | 26
3 | NO | CAR | 34 | 13
3 | PIT | CHI | 17 | 23
3 | ATL | DET | 30 | 26
3 | TB | MIN | 17 | 34
3 | HOU | NE | 33 | 36
3 | SEA | TEN | 27 | 33
3 | CIN | GB | 24 | 27
3 | KC | LAC | 24 | 10
3 | OAK | WAS | 10 | 27
3 | DAL | ARI | 28 | 17
4 | CHI | GB | 14 | 35
4 | NO | MIA | 20 | 0
4 | TEN | HOU | 14 | 57
4 | JAX | NYJ | 20 | 23
4 | CAR | NE | 33 | 30
4 | DET | MIN | 14 | 7
4 | BUF | ATL | 23 | 17
4 | PIT | BAL | 26 | 9
4 | CIN | CLE | 31 | 7
4 | LAR | DAL | 35 | 30
4 | PHI | LAC | 26 | 24
4 | NYG | TB | 23 | 25
4 | SF | ARI | 15 | 18
4 | OAK | DEN | 10 | 16
4 | IND | SEA | 18 | 46
4 | WAS | KC | 20 | 29
5 | NE | TB | 19 | 14 | ATL
5 | NYJ | CLE | 17 | 14 | DEN
5 | CAR | DET | 27 | 24 | NO
5 | SF | IND | 23 | 26 | WAS
5 | TEN | MIA | 10 | 16
5 | BUF | CIN | 16 | 20
5 | LAC | NYG | 27 | 22
5 | JAX | PIT | 30 | 9
5 | ARI | PHI | 7 | 34
5 | SEA | LAR | 16 | 10
5 | BAL | OAK | 30 | 17
5 | GB | DAL | 35 | 31
5 | KC | HOU | 42 | 34
5 | MIN | CHI | 20 | 17
6 | PHI | CAR | 28 | 23 | BUF
6 | CHI | BAL | 27 | 24 | CIN
6 | CLE | HOU | 17 | 33 | DAL
6 | GB | MIN | 10 | 23 | SEA
6 | DET | NO | 38 | 52
6 | MIA | ATL | 20 | 17
6 | NE | NYJ | 24 | 17
6 | SF | WAS | 24 | 26
6 | TB | ARI | 33 | 38
6 | LAR | JAX | 27 | 17
6 | PIT | KC | 19 | 13
6 | LAC | OAK | 17 | 16
6 | NYG | DEN | 23 | 10
6 | IND | TEN | 22 | 36
7 | KC | OAK | 30 | 31 | DET
7 | TB | BUF | 27 | 30 | HOU
7 | CIN | PIT | 14 | 29
7 | BAL | MIN | 16 | 24
7 | NYJ | MIA | 28 | 31
7 | ARI | LAR | 0 | 33
7 | CAR | CHI | 3 | 17
7 | TEN | CLE | 12 | 9
7 | NO | GB | 26 | 17
7 | JAX | IND | 27 | 0
7 | DAL | SF | 40 | 10
7 | SEA | NYG | 24 | 7
7 | DEN | LAC | 0 | 21
7 | ATL | NE | 7 | 23
7 | WAS | PHI | 24 | 34
8 | MIA | BAL | 0 | 40 | ARI
8 | MIN | CLE | 33 | 16 | GB
8 | ATL | NYJ | 25 | 20 | JAX
8 | CAR | TB | 17 | 3 | LAR
8 | SF | PHI | 10 | 33 | NYG
8 | CHI | NO | 12 | 20 | TEN
8 | LAC | NE | 13 | 21
8 | OAK | BUF | 14 | 34
8 | IND | CIN | 23 | 24
8 | HOU | SEA | 38 | 41
8 | DAL | WAS | 33 | 19
8 | PIT | DET | 20 | 15
8 | DEN | KC | 19 | 29
9 | BUF | NYJ | 21 | 34 | CHI
9 | IND | HOU | 20 | 14 | CLE
9 | CIN | JAX | 7 | 23 | LAC
9 | TB | NO | 10 | 30 | MIN
9 | LAR | NYG | 51 | 17 | NE
9 | ATL | CAR | 17 | 20 | PIT
9 | DEN | PHI | 23 | 51
9 | BAL | TEN | 20 | 23
9 | ARI | SF | 20 | 10
9 | WAS | SEA | 17 | 14
9 | KC | DAL | 17 | 28
9 | OAK | MIA | 27 | 24
9 | DET | GB | 30 | 17
10 | SEA | ARI | 22 | 16 | BAL
10 | GB | CHI | 23 | 16 | KC
10 | CLE | DET | 24 | 38 | OAK
10 | PIT | IND | 20 | 17 | PHI
10 | LAC | JAX | 17 | 20
10 | NO | BUF | 47 | 10
10 | NYJ | TB | 10 | 15
10 | MIN | WAS | 38 | 30
10 | CIN | TEN | 20 | 24
10 | HOU | LAR | 7 | 33
10 | DAL | ATL | 7 | 27
10 | NYG | SF | 21 | 31
10 | NE | DEN | 41 | 16
10 | MIA | CAR | 21 | 45
11 | TEN | PIT | 17 | 40 | CAR
11 | JAX | CLE | 30 | 20 | IND
11 | BAL | GB | 19 | 7 | NYJ
11 | ARI | HOU | 23 | 0 | SF
11 | LAR | MIN | 21 | 31
11 | DET | CHI | 7 | 24
11 | WAS | NO | 27 | 24
11 | KC | NYG | 31 | 34
11 | TB | MIA | 9 | 12
11 | BUF | LAC | 24 | 54
11 | CIN | DEN | 20 | 17
11 | NE | OAK | 33 | 8
11 | PHI | DAL | 37 | 9
11 | ATL | SEA | 34 | 31
11 | HOU | BAL | 16 | 23
12 | MIN | DET | 30 | 23
12 | LAC | DAL | 28 | 6
12 | NYG | WAS | 10 | 20
12 | BUF | KC | 16 | 10
12 | TEN | IND | 20 | 16
12 | CLE | CIN | 16 | 30
12 | TB | ATL | 20 | 34
12 | MIA | NE | 17 | 35
12 | CHI | PHI | 3 | 31
12 | CAR | NYJ | 35 | 27
12 | NO | LAR | 20 | 26
12 | SEA | SF | 24 | 13
12 | JAX | ARI | 24 | 27
12 | DEN | OAK | 14 | 21
12 | GB | PIT | 28 | 31
12 | PIT | CIN | 23 | 20
13 | WAS | DAL | 14 | 38
13 | MIN | ATL | 14 | 9
13 | HOU | TEN | 13 | 24
13 | KC | NYJ | 31 | 38
13 | CAR | NO | 21 | 31
13 | DEN | MIA | 9 | 35
13 | DET | BAL | 20 | 44
13 | NE | BUF | 23 | 3
13 | SF | CHI | 15 | 14
13 | TB | GB | 20 | 26
13 | IND | JAX | 10 | 30
13 | CLE | LAC | 10 | 19
13 | NYG | OAK | 17 | 24
13 | LAR | ARI | 32 | 16
13 | PHI | SEA | 10 | 24
13 | NE | MIA | 20 | 27
14 | NO | ATL | 17 | 20
14 | IND | BUF | 7 | 13
14 | DET | TB | 24 | 21
14 | OAK | KC | 15 | 26
14 | SEA | JAX | 24 | 30
14 | SF | HOU | 26 | 16
14 | GB | CLE | 27 | 21
14 | CHI | CIN | 33 | 7
14 | MIN | CAR | 24 | 31
14 | WAS | LAC | 13 | 30
14 | NYJ | DEN | 0 | 23
14 | TEN | ARI | 7 | 12
14 | DAL | NYG | 30 | 10
14 | PHI | LAR | 43 | 35
14 | BAL | PIT | 38 | 39
14 | ATL | TB | 24 | 21
15 | DEN | IND | 25 | 13
15 | CHI | DET | 10 | 20
15 | LAC | KC | 13 | 30
15 | HOU | JAX | 7 | 45
15 | BAL | CLE | 27 | 10
15 | GB | CAR | 24 | 31
15 | MIA | BUF | 16 | 24
15 | CIN | MIN | 7 | 34
15 | ARI | WAS | 15 | 20
15 | PHI | NYG | 34 | 29
15 | NYJ | NO | 19 | 31
15 | LAR | SEA | 42 | 7
15 | TEN | SF | 23 | 25
15 | NE | PIT | 27 | 24
15 | DAL | OAK | 20 | 17
15 | OAK | PHI | 10 | 19
16 | IND | BAL | 16 | 23
16 | MIN | GB | 16 | 0
16 | DET | CIN | 17 | 26
16 | MIA | KC | 13 | 29
16 | BUF | NE | 16 | 37
16 | CLE | CHI | 3 | 20
16 | TB | CAR | 19 | 22
16 | ATL | NO | 13 | 23
16 | DEN | WAS | 11 | 27
16 | LAR | TEN | 27 | 23
16 | LAC | NYJ | 14 | 7
16 | JAX | SF | 33 | 44
16 | SEA | DAL | 21 | 12
16 | NYG | ARI | 0 | 23
16 | PIT | HOU | 34 | 6
16 | ARI | SEA | 26 | 24
17 | CAR | ATL | 10 | 22
17 | CIN | BAL | 31 | 27
17 | JAX | TEN | 10 | 15
17 | NO | TB | 24 | 31
17 | CLE | PIT | 24 | 28
17 | GB | DET | 11 | 35
17 | HOU | IND | 13 | 22
17 | BUF | MIA | 22 | 16
17 | CHI | MIN | 10 | 23
17 | NYJ | NE | 6 | 26
17 | WAS | NYG | 10 | 18
17 | DAL | PHI | 6 | 0
17 | OAK | LAC | 10 | 30
17 | KC | DEN | 27 | 24
17 | SF | LAR | 34 | 13