Spreadsheet: 145960d1331831523-index-and-match-formula-example-index
Sheet: Sales by Product

 |  |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 31 | 32 | 33 | 34 | 35 | 36 | 37 | 38 | 39 | 40 | 41 | 42 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 31 | 32 | 33 | 34 | 35 | 36 | 37 | 38 | 39 | 40 | 41
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Product 1 | Product 2 | Product 3 | Product 4 | Product 5 | Product 6 | Product 7 | Product 8 |  |  |  |  |  |  |  |  |  |  |  |  | Product 1 | Product 2 | Product 3 | Product 4 | Product 5 | Product 6 | Product 7 | Product 8
 |  |  | 4.4mm |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 73 | 92 | 83 | 78 | 82 | 94 | 67 | 58 |  |  |  |  |  |  |  |  | 104.710413813542 |  |  |  | 76 | 95 | 98 | 57 | 82 | 86 | 66 | 62 |  |  |  |  |  |  |  |  | 104.710413813542
 |  |  | 6.4mm |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 88 | 55 | 72 | 66 | 97 | 90 | 66 | 74 |  |  |  |  |  |  |  |  | 2664.116052969207 |  |  |  | 53 | 65 | 69 | 95 | 74 | 91 | 82 | 72 |  |  |  |  |  |  |  |  | 2664.116052969207
 |  |  | 6.8mm |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 93 | 96 | 54 | 92 | 72 | 87 | 100 | 81 |  |  |  |  |  |  |  |  | 528.3807695801844 |  |  |  | 75 | 98 | 77 | 54 | 58 | 94 | 73 | 63 |  |  |  |  |  |  |  |  | 528.3807695801844
 |  |  | 7.14mm |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 70 | 52 | 61 | 73 | 66 | 71 | 61 | 81 |  |  |  |  |  |  |  |  | 0 |  |  |  | 95 | 59 | 63 | 87 | 97 | 61 | 69 | 72 |  |  |  |  |  |  |  |  | 0
 |  |  | 7.4mm |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 76 | 62 | 92 | 55 | 62 | 50 | 65 | 56 |  |  |  |  |  |  |  |  | 0 |  |  |  | 55 | 74 | 60 | 71 | 96 | 80 | 82 | 99 |  |  |  |  |  |  |  |  | 0
 |  |  | 7.5mm |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 70 | 98 | 58 | 82 | 57 | 56 | 80 | 54 |  |  |  |  |  |  |  |  | 330.4870078821292 |  |  |  | 95 | 54 | 90 | 53 | 55 | 100 | 94 | 68 |  |  |  |  |  |  |  |  | 330.4870078821292
 |  |  | 8.4mm |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 80 | 100 | 55 | 58 | 83 | 82 | 62 | 99 |  |  |  |  |  |  |  |  | 21.14659520504556 |  |  |  | 58 | 75 | 89 | 81 | 59 | 90 | 58 | 85 |  |  |  |  |  |  |  |  | 21.14659520504556
 |  |  | 8.8mm |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 62 | 53 | 63 | 86 | 99 | 67 | 68 | 79 |  |  |  |  |  |  |  |  | 6.474486872192821 |  |  |  | 77 | 89 | 92 | 76 | 58 | 99 | 90 | 75 |  |  |  |  |  |  |  |  | 6.474486872192821
 |  |  | 9.1mm |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 66 | 73 | 75 | 51 | 74 | 100 | 92 | 96 |  |  |  |  |  |  |  |  | 0 |  |  |  | 94 | 90 | 64 | 80 | 61 | 74 | 87 | 81 |  |  |  |  |  |  |  |  | 0
 |  |  | 9.5mm |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 94 | 65 | 98 | 82 | 75 | 70 | 90 | 74 |  |  |  |  |  |  |  |  | 0 |  |  |  | 52 | 92 | 81 | 75 | 66 | 57 | 63 | 74 |  |  |  |  |  |  |  |  | 0
 |  |  | 10.28mm |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 58 | 80 | 65 | 72 | 70 | 84 | 82 | 84 |  |  |  |  |  |  |  |  | 0 |  |  |  | 78 | 86 | 71 | 50 | 98 | 67 | 78 | 88 |  |  |  |  |  |  |  |  | 0
 |  |  | 10.4mm |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 69 | 51 | 87 | 95 | 78 | 85 | 57 | 88 |  |  |  |  |  |  |  |  | 0 |  |  |  | 82 | 55 | 89 | 83 | 58 | 93 | 98 | 99 |  |  |  |  |  |  |  |  | 0
 |  |  | 10.8mm |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 93 | 82 | 64 | 74 | 88 | 71 | 93 | 50 |  |  |  |  |  |  |  |  | 0.5212746648758768 |  |  |  | 85 | 82 | 87 | 70 | 90 | 77 | 77 | 63 |  |  |  |  |  |  |  |  | 0.5212746648758768
 |  |  | 11.3mm |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 56 | 77 | 69 | 63 | 99 | 83 | 53 | 99 |  |  |  |  |  |  |  |  | 4.721582977452542 |  |  |  | 67 | 55 | 85 | 67 | 77 | 51 | 91 | 61 |  |  |  |  |  |  |  |  | 4.721582977452542
 |  |  | 11.5mm |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 98 | 84 | 67 | 99 | 52 | 85 | 99 | 91 |  |  |  |  |  |  |  |  | 0 |  |  |  | 81 | 61 | 67 | 96 | 92 | 58 | 63 | 66 |  |  |  |  |  |  |  |  | 0
 |  |  | 12.4mm |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 63 | 62 | 89 | 71 | 68 | 100 | 91 | 72 |  |  |  |  |  |  |  |  | 0 |  |  |  | 79 | 63 | 91 | 65 | 84 | 60 | 65 | 69 |  |  |  |  |  |  |  |  | 0
 |  |  | 12.8mm |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 97 | 84 | 63 | 50 | 58 | 56 | 53 | 78 |  |  |  |  |  |  |  |  | 10.29803770765998 |  |  |  | 97 | 82 | 94 | 99 | 52 | 84 | 95 | 52 |  |  |  |  |  |  |  |  | 10.29803770765998
 |  |  | 13.1mm |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 69 | 87 | 96 | 84 | 54 | 89 | 55 | 69 |  |  |  |  |  |  |  |  | 0 |  |  |  | 57 | 79 | 85 | 64 | 90 | 98 | 72 | 88 |  |  |  |  |  |  |  |  | 0
 |  |  | 13.5mm |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 84 | 50 | 71 | 87 | 98 | 78 | 79 | 98 |  |  |  |  |  |  |  |  | 0 |  |  |  | 100 | 87 | 77 | 97 | 54 | 62 | 54 | 90 |  |  |  |  |  |  |  |  | 0
 |  |  | 15mm |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 89 | 76 | 89 | 64 | 72 | 69 | 51 | 72 |  |  |  |  |  |  |  |  | 10.93103078076063 |  |  |  | 81 | 89 | 62 | 88 | 95 | 82 | 72 | 63 |  |  |  |  |  |  |  |  | 10.93103078076063
 |  |  | 15.3mm |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 59 | 86 | 52 | 97 | 84 | 56 | 80 | 87 |  |  |  |  |  |  |  |  | 0.2761018401315359 |  |  |  | 100 | 90 | 84 | 74 | 88 | 58 | 72 | 82 |  |  |  |  |  |  |  |  | 0.2761018401315359
 |  |  | 15.5mm |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 92 | 50 | 91 | 62 | 61 | 100 | 55 | 74 |  |  |  |  |  |  |  |  | 1.402323115792226 |  |  |  | 54 | 97 | 74 | 70 | 64 | 53 | 67 | 55 |  |  |  |  |  |  |  |  | 1.402323115792226
 |  |  | 16.8mm |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 64 | 86 | 56 | 87 | 95 | 57 | 80 | 98 |  |  |  |  |  |  |  |  | 0 |  |  |  | 59 | 53 | 59 | 87 | 57 | 96 | 100 | 53 |  |  |  |  |  |  |  |  | 0
 |  |  | 17.5mm |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 54 | 91 | 58 | 56 | 72 | 54 | 56 | 65 |  |  |  |  |  |  |  |  | 0 |  |  |  | 85 | 89 | 80 | 80 | 97 | 71 | 67 | 67 |  |  |  |  |  |  |  |  | 0
 |  |  | 19.5mm |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 67 | 73 | 89 | 68 | 63 | 75 | 93 | 58 |  |  |  |  |  |  |  |  | 0 |  |  |  | 93 | 87 | 74 | 72 | 69 | 80 | 97 | 54 |  |  |  |  |  |  |  |  | 0
 |  |  | 21.52mm |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 50 | 63 | 65 | 59 | 88 | 57 | 63 | 80 |  |  |  |  |  |  |  |  | 0 |  |  |  | 67 | 71 | 84 | 100 | 69 | 93 | 99 | 50 |  |  |  |  |  |  |  |  | 0
 |  |  | Lam |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2573.210381769505 | 5.962989515707606 | 0 | 787.5478310558767 | 316.6677368307149 | 0 | 0.07673823716974124 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 3683.465677408973 |  |  |  | 2573.210381769505 | 5.962989515707606 | 0 | 787.5478310558767 | 316.6677368307149 | 0 | 0.07673823716974124 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 3683.465677408973