Steve 1962
Active Member
- Joined
- Jan 3, 2006
- Messages
- 349
- Office Version
- 365
- Platform
- Windows
Hi
I am tracking football scores but depending on the draw, there are two team columns and teams can be in either of the two columns (with their respective scores). In the example, this is columns B and D. However, these teams can alternate between either column which is making searching difficult. I would like to display the result as they are in rows 29 to 31 by placing the search criteria in cell A29 (the round number) and cell B29 (team name) to produce their score in cells C29 to C31.
Thanks
I am tracking football scores but depending on the draw, there are two team columns and teams can be in either of the two columns (with their respective scores). In the example, this is columns B and D. However, these teams can alternate between either column which is making searching difficult. I would like to display the result as they are in rows 29 to 31 by placing the search criteria in cell A29 (the round number) and cell B29 (team name) to produce their score in cells C29 to C31.
Thanks
Book1 | |||||||
---|---|---|---|---|---|---|---|
A | B | C | D | E | |||
1 | Round | Team_For1 | For1 | Team_For2 | For2 | ||
2 | 1 | Eels | 8 | Bulldogs | 2 | ||
3 | 1 | Raiders | 24 | Titans | 6 | ||
4 | 1 | Cowboys | 21 | Broncos | 28 | ||
5 | 1 | Knights | 20 | Warriors | 0 | ||
6 | 1 | Rabbitohs | 22 | Sharks | 18 | ||
7 | 1 | Panthers | 20 | Roosters | 14 | ||
8 | 1 | Sea Eagles | 4 | Storm | 18 | ||
9 | 1 | Dragons | 14 | Tigers | 24 | ||
10 | 2 | Bulldogs | 16 | Cowboys | 24 | ||
11 | 2 | Dragons | 28 | Panthers | 32 | ||
12 | 2 | Broncos | 22 | Rabbitohs | 18 | ||
13 | 2 | Warriors | 6 | Raiders | 20 | ||
14 | 2 | Roosters | 8 | Sea Eagles | 9 | ||
15 | 2 | Sharks | 10 | Storm | 12 | ||
16 | 2 | Tigers | 24 | Knights | 42 | ||
17 | 2 | Titans | 6 | Eels | 46 | ||
18 | 3 | Broncos | 6 | Eels | 34 | ||
19 | 3 | Cowboys | 36 | Titans | 6 | ||
20 | 3 | Roosters | 28 | Rabbitohs | 12 | ||
21 | 3 | Warriors | 18 | Dragons | 0 | ||
22 | 3 | Sharks | 16 | Tigers | 28 | ||
23 | 3 | Storm | 6 | Raiders | 22 | ||
24 | 3 | Panthers | 14 | Knights | 14 | ||
25 | 3 | Sea Eagles | 32 | Bulldogs | 6 | ||
26 | |||||||
27 | |||||||
28 | Round | Team | Score | ||||
29 | 1 | Raiders | 24 | ||||
30 | 2 | Raiders | 20 | ||||
31 | 3 | Raiders | 22 | ||||
Sheet8 |
Cell Formulas | ||
---|---|---|
Range | Formula | |
A30:A31 | A30 | =A29+1 |
B30:B31 | B30 | =B29 |