dan_bucharest
New Member
- Joined
- Jul 13, 2009
- Messages
- 20
Ok. We have a set of data like this:
There are 16 sheets named player1, player2 etc. Example player1.
Then when first round is played the new round is from left players. Note that player1 maybe is in column D not only in column A.
The problem is this. In cell A4 from sheet player1, we ask excel to search data in cell C2 from sheet player1 (the data is player1 and i think that cell C2 must be text) in sheet AllPlayers in A1:D8 range. If it find the data we ask excel to put this data (what is in cell C2=player1) in cell A4 and in cell B4 and C4 the score and in D4 the opponent. BUT IF IT NOT FIND IT THEN IT LOOK IN A1:A8 RANGE FROM SHEET ALLPLAYERS, SEARCH FOR DATA AND PUTS IN CELL C4 THE DATA AND IN C1, C2 AND C3 THE OTHER DATA.
Hope i make myself understood.
When new games is played like this:
then in sheet player1 in cell A5 to D5 the functions must be again entered to make another result.
Excel Workbook | ||||||
---|---|---|---|---|---|---|
A | B | C | D | |||
1 | player1 | 6 | 4 | player2 | ||
2 | player3 | 5 | 6 | player4 | ||
3 | player5 | 1 | 6 | player6 | ||
4 | player7 | 0 | 6 | player8 | ||
5 | player9 | 4 | 6 | player10 | ||
6 | player11 | 6 | 3 | player12 | ||
7 | player13 | 6 | 2 | player14 | ||
8 | player15 | 3 | 6 | player16 | ||
AllPlayers |
There are 16 sheets named player1, player2 etc. Example player1.
Excel Workbook | |||||||
---|---|---|---|---|---|---|---|
A | B | C | D | E | |||
1 | |||||||
2 | player1 | ||||||
3 | |||||||
4 | |||||||
5 | |||||||
6 | |||||||
7 | |||||||
8 | |||||||
9 | |||||||
player1 |
Then when first round is played the new round is from left players. Note that player1 maybe is in column D not only in column A.
Excel Workbook | ||||||
---|---|---|---|---|---|---|
A | B | C | D | |||
11 | player5 | 4 | 6 | player1 | ||
12 | player7 | 2 | 6 | player5 | ||
13 | player3 | 6 | 1 | player11 | ||
14 | player13 | 6 | 0 | player16 | ||
AllPlayers |
The problem is this. In cell A4 from sheet player1, we ask excel to search data in cell C2 from sheet player1 (the data is player1 and i think that cell C2 must be text) in sheet AllPlayers in A1:D8 range. If it find the data we ask excel to put this data (what is in cell C2=player1) in cell A4 and in cell B4 and C4 the score and in D4 the opponent. BUT IF IT NOT FIND IT THEN IT LOOK IN A1:A8 RANGE FROM SHEET ALLPLAYERS, SEARCH FOR DATA AND PUTS IN CELL C4 THE DATA AND IN C1, C2 AND C3 THE OTHER DATA.
Hope i make myself understood.
When new games is played like this:
Excel Workbook | ||||||
---|---|---|---|---|---|---|
A | B | C | D | |||
11 | player5 | 4 | 6 | player1 | ||
12 | player7 | 2 | 6 | player5 | ||
13 | player3 | 6 | 1 | player11 | ||
14 | player13 | 6 | 0 | player16 | ||
AllPlayers |
then in sheet player1 in cell A5 to D5 the functions must be again entered to make another result.
Excel Workbook | ||||||
---|---|---|---|---|---|---|
A | B | C | D | |||
1 | ||||||
2 | player1 | |||||
3 | ||||||
4 | player1 | 6 | 4 | player2 | ||
5 | player5 | 4 | 6 | player1 | ||
6 | ||||||
player1 |