Spreadsheet: 889447d1740240177-2-way-look-up-formula-to-transpose-data-from-calculation-sh-to-sample-results-sheet-calculation
Sheet: SAMPLE RESULTS

DAT | DATA | DATA | DATA | DATA | DATA | DATA | DATA | ROUND | Item No | 24 | 30 | 11 | 33 | 12 | 26 |  |  |  | 24 | 30 | 11 | 33 | 12 | 26
DAT | DAT | FR | 0 | 0 | 0 | 0 | 0 | 721 | 2 | 2938 | 4260 | 5880 |  |  |  |  |  | 2 | 2938 | 4260 | 5880
DAT | DAT | FR | 0 | 0 | 0 | 0 | 0 | 247 | 3 | 1187 | 1774 | 2534 | 192 |  |  |  |  | 3 | 1187 | 1774 | 2534 | 192
DAT | DAT | FR | 0 | 0 | 0 | 0 | 0 | 24 | 4 |  |  |  |  |  |  |  |  | 4 | 0 | 10060
DAT | DAT | FR | 0 | 0 | 0 | 0 | 0 | 407 | 5 |  |  |  |  |  |  |  |  | 5 | 0 | 3049
DAT | DAT | FR | 0 | 0 | 0 | 0 | 0 | 722 | 6 |  |  |  |  |  |  |  |  | 6 | 0 | 4979
DAT | DAT | FR | 0 | 0 | 0 | 0 | 0 | 11204 | 7 |  |  |  |  |  |  |  |  | 7 | 512 | 1112 | 3486
DAT | DAT | FR | 0 | 0 | 0 | 0 | 0 | 540 | 8 |  |  |  |  |  |  |  |  | 8 | 0 | 1691
DAT | DAT | FR | 0 | 0 | 0 | 0 | 0 | 3012 | 9 |  |  |  |  |  |  |  |  | 9 | 0 | 25575 |  |  | 64260
DAT | DAT | FR | 0 | 0 | 0 | 0 | 0 | 860 | 10 |  |  |  |  |  |  |  |  | 10 | 4595 | 4446 |  |  | 9732
DAT | DAT | FR | 0 | 0 | 0 | 0 | 45 | 155 | 11 |  |  |  |  |  |  |  |  | 11 | 7071 | 5816 |  |  | 8133
DAT | DAT | ES | 0 | 0 | 0 | 0 | 0 | 317 | 12 |  |  |  |  |  |  |  |  | 12 | 359 | 1284 | 5811
DAT | DAT | FR | 0 | 0 | 0 | 0 | 0 | 591 | 13 |  |  |  |  |  |  |  |  | 13 | 0 | 54427 | 189426
DAT | DAT | FR | 0 | 0 | 0 | 0 | 0 | 92 | 14 |  |  |  |  |  |  |  |  | 14 | 282 | 467 | 950
DAT | DAT | ES | 0 | 0 | 0 | 0 | 0 | 345 | 15 |  |  |  |  |  |  |  |  | 15 | 3373 | 6685 | 16854 | 1848
DAT | DAT | BE | 0 | 0 | 0 | 0 | 0 | 671 | 16 |  |  |  |  |  |  |  |  | 16 | 103 | 121 |  |  |  | 21
DAT | DAT | FR | 0 | 0 | 0 | 0 | 0 | 4036 | 17 |  |  |  |  |  |  |  |  | 17 | 0 | 2081 | 4540
DAT | DAT | FR | 0 | 0 | 0 | 0 | 0 | 21 | 18 |  |  |  |  |  |  |  |  | 18 | 0 | 103
DAT | DAT | FR | 0 | 0 | 0 | 0 | 0 | 28 | 19 |  |  |  |  |  |  |  |  | 19 | 0 | 23144
DAT | DAT | FR | 0 | 0 | 0 | 0 | 0 | 18 | 20 |  |  |  |  |  |  |  |  | 20 | 31530 | 41280 |  | 19824 |  | 13644
DAT | DAT | FR | 0 | 0 | 0 | 0 | 0 | 57 | 21 |  |  |  |  |  |  |  |  | 21 | 0 | 1526 |  |  |  | 1009
DAT | DAT | FR | 0 | 0 | 0 | 0 | 0 | 905 | 22 |  |  |  |  |  |  |  |  | 22 | 0 | 205
DAT | DAT | FR | 0 | 0 | 0 | 0 | 0 | 54 | 23 |  |  |  |  |  |  |  |  | 23 | 0 | 113336
DAT | DAT | BE | 0 | 0 | 0 | 0 | 0 | 186 | 24 |  |  |  |  |  |  |  |  | 24 | 0 | 2314
DAT | DAT | DE | 0 | 0 | 0 | 0 | 0 | 83 | 25 |  |  |  |  |  |  |  |  | 25 | 0 | 1812 |  |  |  | 980
DAT | DAT | ES | 0 | 0 | 0 | 0 | 0 | 223 | 26 |  |  |  |  |  |  |  |  | 26 | 0 | 1390 |  |  |  | 1182
DAT | DAT | FR | 0 | 0 | 0 | 0 | 0 | 505 | 27 |  |  |  |  |  |  |  |  | 27 | 0 | 2096 |  |  |  | 477
DAT | DAT | NL | 0 | 0 | 0 | 0 | 0 | 83 | 28 |  |  |  |  |  |  |  |  | 28 | 0 | 8219 |  |  |  | 2130
DAT | DAT | FR | 0 | 0 | 0 | 0 | 0 | 435 | 29 |  |  |  |  |  |  |  |  | 29 | 0 | 17367 |  |  |  | 27648
DAT | DAT | IT | 0 | 0 | 0 | 0 | 0 | 34 | 30 |  |  |  |  |  |  |  |  | 30 | 0 | 0
DAT | DAT | FR | 0 | 0 | 0 | 0 | 60 | 850 | 31 |  |  |  |  |  |  |  |  | 31 | 0 | 589
DAT | DAT | FR | 0 | 0 | 0 | 0 | 0 | 292 | 32 |  |  |  |  |  |  |  |  | 32 | 0 | 6221 |  |  |  | 2699
DAT | DAT | FR | 0 | 0 | 0 | 0 | 30 | 72 | 33 |  |  |  |  |  |  |  |  | 33 | 0 | 401 |  |  |  | 54
DAT | DAT | PT | 0 | 0 | 0 | 0 | 0 | 83 | 34 |  |  |  |  |  |  |  |  | 34 | 0 | 364 |  |  |  | 832
DAT | DAT | IT | 0 | 0 | 0 | 0 | 0 | 224 | 35 |  |  |  |  |  |  |  |  | 35 | 0 | 723 |  |  |  | 319
DAT | DAT | ES | 0 | 0 | 0 | 0 | 0 | 27 | 36 |  |  |  |  |  |  |  |  | 36 | 0 | 2475 |  |  |  | 955
DAT | DAT | FR | 0 | 0 | 0 | 0 | 0 | 128 | 37 |  |  |  |  |  |  |  |  | 37 | 0 | 529
DAT | DAT | FR | 0 | 0 | 0 | 0 | 60 | 79 | 38 |  |  |  |  |  |  |  |  | 38 | 0 | 1725
DAT | DAT | GB | 0 | 0 | 0 | 0 | 30 | 75 | 39 |  |  |  |  |  |  |  |  | 39 | 0 | 645 |  |  |  | 314
DAT | DAT | FR | 0 | 0 | 0 | 0 | 450 | 1475 | 40 |  |  |  |  |  |  |  |  | 40 | 589 | 831 |  |  |  | 1024
DAT | DAT | FR | 0 | 0 | 0 | 0 | 15 | 54 | 41 |  |  |  |  |  |  |  |  | 41 | 0 | 2426 |  |  |  | 518
DAT | DAT | IR | 0 | 0 | 0 | 0 | 30 | 152 | 42 |  |  |  |  |  |  |  |  | 42 | 0 | 189 |  |  |  | 62
DAT | DAT | FR | 0 | 0 | 0 | 0 | 15 | 72 | 43 |  |  |  |  |  |  |  |  | 43 | 0 | 588 |  |  |  | 222
DAT | DAT | FR | 0 | 0 | 0 | 0 | 30 | 45 | 44 |  |  |  |  |  |  |  |  | 44 | 34571 | 22471
DAT | DAT | FR | 0 | 0 | 0 | 0 | 150 | 120 | 45 |  |  |  |  |  |  |  |  | 45 | 0 | 7080
DAT | DAT | FR | 0 | 0 | 0 | 0 | 30 | 40 | 46 |  |  |  |  |  |  |  |  | 46 | 401 | 985 | 3486
DAT | DAT | FR | 0 | 0 | 0 | 0 | 15 | 24 | 47 |  |  |  |  |  |  |  |  | 47 | 0 | 2144 | 5811
DAT | DAT | FR | 0 | 0 | 0 | 0 | 15 | 9 | 48 |  |  |  |  |  |  |  |  | 48 | 0 | 2306
DAT | DAT | IN | 0 | 0 | 0 | 0 | 0 | 419 | 49 |  |  |  |  |  |  |  |  | 49 | 0 | 308
DAT | DAT | FR | 0 | 0 | 0 | 0 | 0 | 1922 | 50 |  |  |  |  |  |  |  |  | 50 | 0 | 1025
DAT | DAT | FR | 0 | 0 | 0 | 0 | 15 | 5 | 51 |  |  |  |  |  |  |  |  | 51 | 1008 | 1219 |  |  | 3757
DAT | DAT | FR | 0 | 0 | 0 | 0 | 0 | 1184 | 52 |  |  |  |  |  |  |  |  | 52 | 957 | 1990 |  |  | 9124
DAT | DAT | FR | 0 | 0 | 0 | 0 | 0 | 74 | 53 |  |  |  |  |  |  |  |  | 53 | 717 | 1498 | 4489
DAT | DAT | FR | 0 | 0 | 0 | 0 | 0 | 486 | 54 |  |  |  |  |  |  |  |  | 54 | 0 | 239 |  |  |  | 111