Steviefiege
Board Regular
- Joined
- Aug 29, 2018
- Messages
- 66
Hi,
Below is my main data table of all my players:
Sheet 1
<tbody>
</tbody>
On Sheet 2 i have individual positions:
Sheet 2
<tbody>
</tbody>
What i'm wanting to do on a separate sheet (sheet 3) is find which players are best in each position. For example, if i put my top rated player in (J.Coppinger) & at the side of his name put CM i want it to look up his attributes from sheet 1 & match them with the attributes listed for CM in sheet 2 then display the results in sheet 3. Is this possible?
Below is my main data table of all my players:
Sheet 1
| Name | Total Rat. | Cor | Cro | Dri | Fin | Fir | Fre | Hea | Lon | L Th | Mar | Pas | Pen | Tck | Tec | Agg | Ant | Bra | Cmp | Cnt | Dec | Det | Fla | Ldr | OtB | Pos | Tea | Vis | Wor | Acc | Agi | Bal | Jum | Nat | Pac | Sta | Str |
| James Coppinger | 403 | 10 | 14 | 15 | 12 | 14 | 11 | 4 | 7 | 1 | 8 | 14 | 10 | 10 | 15 | 7 | 13 | 11 | 12 | 12 | 10 | 14 | 13 | 15 | 14 | 10 | 15 | 15 | 14 | 8 | 11 | 14 | 7 | 14 | 8 | 14 | 7 |
| Andy Boyle | 389 | 5 | 7 | 4 | 5 | 10 | 3 | 14 | 4 | 7 | 14 | 12 | 9 | 14 | 12 | 12 | 13 | 14 | 13 | 13 | 13 | 16 | 4 | 14 | 8 | 14 | 13 | 9 | 14 | 11 | 10 | 13 | 14 | 14 | 10 | 14 | 13 |
| Carlton Cole | 389 | 6 | 11 | 10 | 12 | 9 | 5 | 14 | 9 | 9 | 11 | 12 | 12 | 11 | 9 | 10 | 11 | 11 | 8 | 12 | 9 | 12 | 12 | 9 | 12 | 8 | 17 | 11 | 10 | 11 | 8 | 14 | 15 | 12 | 12 | 10 | 15 |
| Tommy Rowe | 388 | 10 | 11 | 10 | 12 | 11 | 10 | 7 | 11 | 6 | 9 | 11 | 8 | 12 | 11 | 9 | 12 | 12 | 12 | 12 | 12 | 10 | 11 | 12 | 10 | 11 | 14 | 10 | 13 | 9 | 12 | 11 | 9 | 15 | 9 | 14 | 10 |
| John Marquis | 388 | 4 | 6 | 9 | 13 | 11 | 11 | 13 | 7 | 5 | 6 | 10 | 10 | 11 | 11 | 14 | 10 | 14 | 10 | 11 | 10 | 15 | 9 | 12 | 12 | 8 | 15 | 8 | 15 | 12 | 10 | 12 | 14 | 12 | 12 | 13 | 13 |
| Mathieu Baudry | 380 | 6 | 6 | 11 | 9 | 13 | 8 | 14 | 8 | 4 | 14 | 10 | 6 | 14 | 11 | 8 | 14 | 16 | 13 | 8 | 7 | 13 | 9 | 9 | 9 | 11 | 12 | 9 | 11 | 9 | 12 | 14 | 14 | 13 | 10 | 14 | 11 |
| Craig Alcock | 379 | 8 | 9 | 6 | 9 | 10 | 8 | 13 | 9 | 9 | 12 | 9 | 6 | 14 | 9 | 16 | 10 | 14 | 11 | 11 | 9 | 14 | 2 | 12 | 9 | 10 | 14 | 8 | 14 | 11 | 10 | 11 | 10 | 15 | 11 | 14 | 12 |
| Danny Andrew | 376 | 12 | 12 | 10 | 7 | 11 | 10 | 6 | 10 | 12 | 11 | 12 | 1 | 12 | 12 | 8 | 10 | 10 | 11 | 12 | 10 | 12 | 5 | 9 | 11 | 12 | 14 | 11 | 14 | 12 | 10 | 11 | 8 | 12 | 12 | 13 | 11 |
| Matty Blair | 374 | 7 | 12 | 12 | 10 | 10 | 6 | 9 | 8 | 3 | 10 | 10 | 6 | 10 | 10 | 8 | 10 | 8 | 11 | 10 | 10 | 14 | 15 | 7 | 12 | 10 | 12 | 11 | 17 | 12 | 11 | 10 | 8 | 15 | 13 | 16 | 11 |
| Ben Whiteman | 360 | 5 | 9 | 9 | 9 | 7 | 10 | 6 | 9 | 7 | 9 | 12 | 11 | 10 | 10 | 8 | 13 | 11 | 12 | 13 | 11 | 11 | 5 | 10 | 8 | 11 | 12 | 11 | 14 | 9 | 9 | 10 | 12 | 12 | 11 | 14 | 10 |
| Jordan Houghton | 358 | 8 | 7 | 9 | 9 | 11 | 8 | 8 | 8 | 5 | 10 | 12 | 10 | 10 | 12 | 12 | 10 | 12 | 12 | 7 | 11 | 9 | 6 | 9 | 10 | 10 | 15 | 10 | 13 | 10 | 10 | 10 | 9 | 13 | 10 | 14 | 9 |
| Rodney Kongolo | 352 | 5 | 6 | 9 | 7 | 9 | 7 | 10 | 5 | 7 | 11 | 10 | 8 | 13 | 11 | 12 | 11 | 13 | 10 | 11 | 9 | 5 | 4 | 9 | 7 | 11 | 14 | 7 | 12 | 14 | 11 | 13 | 14 | 6 | 13 | 15 | 13 |
| Liam Mandeville | 351 | 6 | 8 | 10 | 13 | 11 | 11 | 8 | 12 | 4 | 5 | 11 | 14 | 5 | 11 | 4 | 10 | 10 | 13 | 9 | 11 | 15 | 10 | 3 | 12 | 7 | 10 | 12 | 10 | 10 | 12 | 12 | 8 | 14 | 10 | 11 | 9 |
| Andrew Williams | 343 | 4 | 8 | 9 | 12 | 11 | 5 | 10 | 7 | 4 | 6 | 9 | 10 | 4 | 9 | 7 | 11 | 8 | 13 | 10 | 9 | 14 | 9 | 9 | 13 | 12 | 10 | 11 | 14 | 10 | 11 | 11 | 11 | 12 | 9 | 12 | 9 |
| Luke McCullough | 341 | 2 | 4 | 9 | 3 | 12 | 9 | 13 | 3 | 6 | 14 | 13 | 5 | 13 | 10 | 5 | 12 | 13 | 13 | 10 | 11 | 3 | 2 | 14 | 4 | 12 | 10 | 7 | 12 | 13 | 8 | 9 | 14 | 15 | 13 | 13 | 12 |
| Alfie May | 341 | 5 | 8 | 9 | 13 | 10 | 8 | 11 | 10 | 3 | 4 | 9 | 12 | 4 | 9 | 8 | 11 | 14 | 10 | 7 | 9 | 16 | 11 | 8 | 12 | 7 | 9 | 7 | 15 | 13 | 14 | 9 | 8 | 8 | 12 | 12 | 6 |
| Niall Mason | 340 | 8 | 11 | 7 | 7 | 8 | 10 | 11 | 8 | 10 | 12 | 11 | 4 | 11 | 9 | 10 | 8 | 10 | 10 | 10 | 11 | 5 | 1 | 7 | 11 | 10 | 11 | 7 | 13 | 12 | 9 | 11 | 9 | 12 | 11 | 13 | 12 |
| Andy Butler | 338 | 3 | 4 | 3 | 6 | 8 | 2 | 16 | 2 | 5 | 13 | 8 | 4 | 15 | 7 | 14 | 12 | 18 | 12 | 11 | 11 | 18 | 2 | 15 | 7 | 12 | 14 | 6 | 14 | 4 | 5 | 12 | 15 | 8 | 6 | 11 | 15 |
| Joe Wright | 325 | 5 | 4 | 6 | 4 | 9 | 4 | 12 | 5 | 6 | 11 | 9 | 3 | 11 | 9 | 11 | 9 | 13 | 9 | 9 | 10 | 12 | 5 | 9 | 9 | 10 | 11 | 10 | 12 | 10 | 7 | 11 | 15 | 11 | 10 | 12 | 12 |
| Cedric Evina | 321 | 7 | 8 | 9 | 9 | 7 | 3 | 6 | 4 | 5 | 7 | 6 | 5 | 8 | 9 | 6 | 8 | 9 | 8 | 8 | 8 | 9 | 10 | 9 | 11 | 9 | 10 | 8 | 15 | 15 | 14 | 11 | 8 | 15 | 14 | 15 | 8 |
| Alfie Beestin | 321 | 8 | 11 | 11 | 9 | 13 | 7 | 3 | 6 | 2 | 4 | 12 | 8 | 6 | 11 | 10 | 8 | 5 | 9 | 9 | 9 | 16 | 13 | 2 | 11 | 5 | 10 | 13 | 12 | 9 | 10 | 14 | 3 | 11 | 9 | 13 | 9 |
| Mitchell Lund | 319 | 3 | 9 | 9 | 3 | 11 | 5 | 8 | 3 | 2 | 10 | 9 | 4 | 10 | 7 | 4 | 11 | 8 | 11 | 10 | 11 | 10 | 5 | 4 | 12 | 12 | 11 | 13 | 12 | 10 | 9 | 13 | 12 | 12 | 12 | 13 | 11 |
| Tom Anderson | 318 | 6 | 6 | 3 | 5 | 8 | 4 | 14 | 6 | 10 | 13 | 8 | 3 | 9 | 5 | 9 | 8 | 14 | 11 | 9 | 10 | 10 | 2 | 10 | 7 | 11 | 13 | 6 | 12 | 9 | 7 | 10 | 16 | 10 | 9 | 13 | 12 |
| Issam Ben Khemis | 317 | 6 | 6 | 12 | 10 | 11 | 7 | 5 | 7 | 3 | 6 | 11 | 8 | 9 | 11 | 4 | 9 | 7 | 11 | 10 | 8 | 3 | 11 | 5 | 10 | 9 | 9 | 11 | 11 | 12 | 11 | 12 | 9 | 11 | 13 | 11 | 8 |
| Danny Amos | 312 | 9 | 10 | 11 | 8 | 10 | 8 | 8 | 7 | 11 | 7 | 9 | 7 | 11 | 9 | 10 | 9 | 6 | 5 | 6 | 5 | 6 | 7 | 6 | 9 | 9 | 9 | 9 | 13 | 12 | 8 | 8 | 6 | 15 | 14 | 8 | 7 |
| Shane Blaney | 299 | 6 | 6 | 4 | 3 | 11 | 6 | 9 | 2 | 3 | 8 | 10 | 5 | 9 | 10 | 9 | 8 | 10 | 6 | 8 | 16 | 9 | 1 | 7 | 9 | 11 | 9 | 5 | 10 | 13 | 11 | 10 | 13 | 15 | 9 | 9 | 9 |
| Will Longbottom | 292 | 5 | 8 | 10 | 13 | 10 | 4 | 9 | 9 | 2 | 2 | 12 | 7 | 6 | 11 | 8 | 7 | 5 | 10 | 6 | 11 | 2 | 10 | 1 | 11 | 10 | 10 | 11 | 11 | 11 | 8 | 10 | 7 | 7 | 12 | 9 | 7 |
| Alex Kiwomya | 291 | 4 | 8 | 8 | 8 | 7 | 4 | 3 | 9 | 2 | 4 | 7 | 6 | 3 | 10 | 12 | 8 | 5 | 7 | 8 | 7 | 12 | 13 | 5 | 12 | 4 | 7 | 5 | 10 | 19 | 12 | 9 | 6 | 14 | 19 | 9 | 5 |
| Ali Suljic | 282 | 6 | 8 | 5 | 6 | 7 | 2 | 8 | 8 | 8 | 8 | 7 | 7 | 8 | 8 | 10 | 8 | 8 | 8 | 8 | 7 | 4 | 1 | 6 | 5 | 8 | 10 | 7 | 11 | 12 | 9 | 12 | 12 | 9 | 12 | 8 | 11 |
| Reece Fielding | 279 | 6 | 3 | 5 | 5 | 8 | 2 | 13 | 2 | 5 | 10 | 8 | 2 | 11 | 6 | 10 | 8 | 11 | 10 | 10 | 9 | 8 | 3 | 9 | 7 | 10 | 11 | 7 | 10 | 6 | 6 | 4 | 13 | 10 | 7 | 10 | 14 |
| Tyler Walker | 246 | 2 | 3 | 2 | 1 | 7 | 1 | 8 | 2 | 6 | 7 | 6 | 2 | 11 | 7 | 8 | 9 | 8 | 8 | 7 | 13 | 6 | 1 | 5 | 4 | 6 | 8 | 5 | 8 | 14 | 11 | 8 | 11 | 14 | 13 | 7 | 7 |
| Myron Gibbons | 225 | 4 | 3 | 8 | 12 | 10 | 4 | 13 | 4 | 1 | 1 | 2 | 5 | 1 | 7 | 7 | 10 | 5 | 6 | 5 | 5 | 5 | 7 | 8 | 13 | 4 | 4 | 5 | 5 | 10 | 9 | 5 | 7 | 11 | 11 | 5 | 3 |
| Rieves Boocock | 212 | 4 | 3 | 10 | 11 | 6 | 4 | 9 | 3 | 1 | 3 | 5 | 4 | 1 | 7 | 7 | 8 | 2 | 11 | 5 | 7 | 2 | 7 | 11 | 13 | 2 | 4 | 5 | 5 | 11 | 7 | 5 | 3 | 7 | 6 | 6 | 7 |
| Cameron Barnett | 205 | 3 | 1 | 10 | 12 | 11 | 1 | 9 | 4 | 1 | 1 | 1 | 3 | 1 | 7 | 7 | 7 | 1 | 4 | 3 | 8 | 7 | 8 | 10 | 9 | 2 | 3 | 4 | 4 | 12 | 10 | 4 | 8 | 7 | 10 | 7 | 5 |
| Branden Horton | 171 | 1 | 1 | 1 | 1 | 1 | 1 | 7 | 1 | 1 | 10 | 4 | 1 | 8 | 1 | 7 | 2 | 6 | 4 | 5 | 12 | 4 | 1 | 9 | 1 | 11 | 3 | 3 | 4 | 9 | 8 | 4 | 12 | 13 | 5 | 4 | 5 |
<tbody>
</tbody>
On Sheet 2 i have individual positions:
Sheet 2
| WB (Right) | Cro | Mar | Pas | Tck | Cnt | Dec | Pos | Tea | Wor | Sta | |||||||||||
| BPD | Fir | Hea | Mar | Pas | Tck | Tec | Agg | Ant | Bra | Cmp | Cnt | Dec | Det | Pos | Vis | Jum | Str | ||||
| WB (Left) | Cro | Mar | Pas | Tck | Cnt | Dec | Pos | Tea | Wor | Sta | |||||||||||
| CM | Fir | Hea | Mar | Pas | Tck | Cnt | Dec | Det | Pos | Tea | Wor | Sta | |||||||||
| BWM | Mar | Tck | Agg | Bra | Det | Pos | Tea | Wor | Acc | Sta | Str | ||||||||||
| Carrilero | Tck | Ant | Dec | Pos | Wor | Acc | Nat | Pac | Sta | Str | |||||||||||
| CF | Dri | Fin | Fir | Hea | Lon | Pas | Tec | Ant | Cmp | Cnt | Dec | Det | OtB | Tea | Vis | Wor | Acc | Agi | Bal | Jum | Str |
<tbody>
</tbody>
What i'm wanting to do on a separate sheet (sheet 3) is find which players are best in each position. For example, if i put my top rated player in (J.Coppinger) & at the side of his name put CM i want it to look up his attributes from sheet 1 & match them with the attributes listed for CM in sheet 2 then display the results in sheet 3. Is this possible?
