Spreadsheet: 743480d1628532627-lookup-data-with-3-criteria-one-of-them-in-merged-cell-lookup
Sheet: Data

 | Area 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Area 2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Area 3
 | Material 1 | Material 2 | Material 3 | Material 4 | Material 5 | Material 6 | Material 7 | Material 8 | Material 9 | Material 10 | Material 11 | Material 12 | Material 13 | Material 14 | Material 15 | Material 16 | Total |  | Material 1 | Material 2 | Material 3 | Material 4 | Material 5 | Material 6 | Material 7 | Material 8 | Material 9 | Material 10 | Material 11 | Material 12 | Material 13 | Material 14 | Material 15 | Material 16 | Total |  | Material 1 | Material 2 | Material 3 | Material 4 | Material 5 | Material 6 | Material 7 | Material 8 | Material 9 | Material 10 | Material 11 | Material 12 | Material 13 | Material 14 | Material 15 | Material 16 | Total
1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 | 30.3 | 0 | 0 | 0 | 0 | 0 | 151.5 | 0 | 0 | 0 | 121.2 | 303
2 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 | 32.9 | 0 | 0 | 0 | 0 | 0 | 164.5 | 0 | 0 | 0 | 131.6 | 329
3 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 | 28.48 | 0 | 0 | 0 | 0 | 0 | 178 | 0 | 0 | 0 | 149.52 | 356
4 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 | 38.90000000000001 | 0 | 0 | 0 | 0 | 0 | 194.5 | 0 | 0 | 0 | 155.6 | 389
5 | 0 | 0 | 0 | 0 | 0 | 3.9 | 0 | 0 | 0 | 0 | 0 | 23.4 | 0 | 0 | 0 | 11.7 | 39 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 | 27.72 | 0 | 0 | 0 | 0 | 0 | 209.88 | 0 | 0 | 0 | 158.4 | 396
6 | 0 | 0 | 0 | 0 | 0 | 3.3 | 0 | 0 | 0 | 0 | 0 | 19.8 | 0 | 0 | 0 | 9.9 | 33 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 | 33.12 | 0 | 0 | 0 | 0 | 0 | 187.68 | 0 | 0 | 0 | 147.2 | 368
7 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 | 35.6 | 0 | 0 | 0 | 0 | 0 | 178 | 0 | 0 | 0 | 142.4 | 356
8 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 | 29.6 | 0 | 0 | 0 | 0 | 0 | 148 | 0 | 0 | 0 | 118.4 | 296
9 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 | 47.32000000000001 | 0 | 0 | 0 | 0 | 0 | 155.48 | 0 | 0 | 0 | 135.2 | 338
10 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 | 28.7 | 0 | 0 | 0 | 0 | 0 | 143.5 | 0 | 0 | 0 | 114.8 | 287
11 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 | 23.9 | 0 | 0 | 0 | 0 | 0 | 119.5 | 0 | 0 | 0 | 95.60000000000001 | 239
12 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 | 24.2 | 0 | 0 | 0 | 0 | 0 | 121 | 0 | 0 | 0 | 96.80000000000001 | 242
13 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 | 22.5 | 0 | 0 | 0 | 0 | 0 | 112.5 | 0 | 0 | 0 | 90 | 225
14 | 0 | 0 | 0 | 0 | 0 | 0.2 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0.8 | 2 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 | 23.5 | 0 | 0 | 0 | 0 | 0 | 117.5 | 0 | 0 | 0 | 94 | 235
15 | 0 | 0 | 0 | 0 | 0 | 0.1 | 0 | 0 | 0 | 0 | 0 | 0.6 | 0 | 0 | 0 | 0.3 | 1 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 | 23.8 | 0 | 0 | 0 | 0 | 0 | 119 | 0 | 0 | 0 | 95.2 | 238
16 | 0 | 0 | 0 | 0 | 0 | 16.3 | 0 | 0 | 0 | 0 | 0 | 97.8 | 0 | 0 | 0 | 48.9 | 163 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 | 23.3 | 0 | 0 | 0 | 0 | 0 | 116.5 | 0 | 0 | 0 | 93.2 | 233
17 | 0 | 0 | 0 | 0 | 0 | 41.1 | 0 | 0 | 0 | 0 | 0 | 246.6 | 0 | 0 | 0 | 123.3 | 411 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 | 24.1 | 0 | 0 | 0 | 0 | 0 | 120.5 | 0 | 0 | 0 | 96.4 | 241
18 | 0 | 0 | 0 | 0 | 0 | 41 | 0 | 0 | 0 | 0 | 0 | 246 | 0 | 0 | 0 | 123 | 410 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 | 23.7 | 0 | 0 | 0 | 0 | 0 | 118.5 | 0 | 0 | 0 | 94.80000000000001 | 237
19 | 0 | 14.99883 | 39.9999 | 0 | 0 | 45.3 | 0 | 0 | 0 | 0 | 0 | 216.80127 | 0 | 0 | 0 | 135.9 | 453 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 | 22.2 | 0 | 0 | 0 | 0 | 0 | 111 | 0 | 0 | 0 | 88.80000000000001 | 222
20 | 0 | 15 | 40.00080000000001 | 0 | 0 | 24 | 0 | 0 | 0 | 0 | 0 | 88.9992 | 0 | 0 | 0 | 72 | 240 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 | 20.5 | 0 | 0 | 0 | 0 | 0 | 102.5 | 0 | 0 | 0 | 82 | 205
21 | 0 | 14.99958 | 39.99888 | 0 | 0 | 28.2 | 0 | 0 | 0 | 0 | 0 | 114.20154 | 0 | 0 | 0 | 84.6 | 282 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 | 22.5 | 0 | 0 | 0 | 0 | 0 | 112.5 | 0 | 0 | 0 | 90 | 225
22 | 0 | 15.00012 | 40.00032 | 0 | 0 | 25.8 | 0 | 0 | 0 | 0 | 0 | 99.79956 | 0 | 0 | 0 | 77.39999999999999 | 258 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 | 18.7 | 0 | 0 | 0 | 0 | 0 | 93.5 | 0 | 0 | 0 | 74.8 | 187
23 | 0 | 0 | 0 | 0 | 0 | 27.5 | 0 | 0 | 0 | 0 | 0 | 165 | 0 | 0 | 0 | 82.5 | 275 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 | 20.7 | 0 | 0 | 0 | 0 | 0 | 103.5 | 0 | 0 | 0 | 82.80000000000001 | 207
24 | 0 | 0 | 0 | 0 | 0 | 26.1 | 0 | 0 | 0 | 0 | 0 | 156.6 | 0 | 0 | 0 | 78.3 | 261 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 | 20.6 | 0 | 0 | 0 | 0 | 0 | 103 | 0 | 0 | 0 | 82.4 | 206
25 | 0 | 15.00489 | 30.000123 | 0 | 0 | 26.1 | 0 | 0 | 0 | 0 | 0 | 111.59577 | 0 | 0 | 0 | 78.3 | 261.000783 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 | 19.2 | 0 | 0 | 0 | 0 | 0 | 96 | 0 | 0 | 0 | 76.80000000000001 | 192
26 | 0 | 14.99745 | 30.00075 | 0 | 0 | 19.5 | 0 | 0 | 0 | 0 | 0 | 72.0018 | 0 | 0 | 0 | 58.5 | 195 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 | 11 | 0 | 0 | 0 | 0 | 0 | 55 | 0 | 0 | 0 | 44 | 110
27 | 0 | 14.9991 | 30.00075 | 0 | 0 | 25.5 | 0 | 0 | 0 | 0 | 0 | 108.00015 | 0 | 0 | 0 | 76.5 | 255 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 | 19.1 | 0 | 0 | 0 | 0 | 0 | 95.5 | 0 | 0 | 0 | 76.4 | 191
28 | 0 | 0 | 0 | 0 | 0 | 24.9 | 0 | 0 | 0 | 0 | 0 | 149.4 | 0 | 0 | 0 | 74.7 | 249 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 | 26.7 | 0 | 0 | 0 | 0 | 0 | 80.10000000000001 | 0 | 0 | 0 | 71.2 | 178
29 | 0 | 0 | 0 | 0 | 0 | 17.45 | 0 | 0 | 0 | 0 | 0 | 226.85 | 0 | 0 | 0 | 104.7 | 349 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 | 27 | 0 | 0 | 0 | 0 | 0 | 81 | 0 | 0 | 0 | 72 | 180
30 | 0 | 15.000484 | 29.999584 | 0 | 0 | 17.3 | 0 | 0 | 0 | 0 | 0 | 179.899932 | 0 | 0 | 0 | 103.8 | 346 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 | 27.54 | 0 | 0 | 0 | 0 | 0 | 64.25999999999999 | 0 | 0 | 0 | 61.2 | 153
31 | 0 | 14.99896 | 30.00105 | 0 | 0 | 31.3 | 0 | 0 | 0 | 0 | 0 | 142.79999 | 0 | 0 | 0 | 93.89999999999999 | 313 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 | 14.6 | 0 | 0 | 0 | 0 | 0 | 73 | 0 | 0 | 0 | 58.40000000000001 | 146