Spreadsheet: 744339d1629188147-lookup-data-with-3-criteria-one-of-them-in-merged-cell-lookup-report
Sheet: Report

 | 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
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 | 32.9 | 0 | 0 | 0 | 164.5 | 0 | 0 | 0 | 0 | 131.6
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 | 28.48 | 0 | 0 | 0 | 178 | 0 | 0 | 0 | 0 | 149.52
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 | 38.90000000000001 | 0 | 0 | 0 | 194.5 | 0 | 0 | 0 | 0 | 155.6
5 | 0 | 0 | 0 | 0 | 0 | 3.9 | 0 | 0 | 0 | 0 | 0 | 23.4 | 0 | 0 | 0 | 11.7 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | 55 | 60 | 0 | 0 | 0 | 0 | 27.72 | 0 | 0 | 0 | 209.88 | 0 | 0 | 0 | 0 | 158.4
6 | 0 | 0 | 0 | 0 | 0 | 3.3 | 0 | 0 | 0 | 0 | 0 | 19.8 | 0 | 0 | 0 | 9.9 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | 80 | 70 | 0 | 0 | 0 | 0 | 33.12 | 0 | 0 | 0 | 187.68 | 0 | 0 | 0 | 0 | 147.2
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 | 35.6 | 0 | 0 | 0 | 178 | 0 | 0 | 0 | 0 | 142.4
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 | 29.6 | 0 | 0 | 0 | 148 | 0 | 0 | 0 | 0 | 118.4
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 | 47.32000000000001 | 0 | 0 | 0 | 155.48 | 0 | 0 | 0 | 0 | 135.2
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 | 28.7 | 0 | 0 | 0 | 143.5 | 0 | 0 | 0 | 0 | 114.8
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 | 23.9 | 0 | 0 | 0 | 119.5 | 0 | 0 | 0 | 0 | 95.60000000000001
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 | 24.2 | 0 | 0 | 0 | 121 | 0 | 0 | 0 | 0 | 96.80000000000001
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 | 22.5 | 0 | 0 | 0 | 112.5 | 0 | 0 | 0 | 0 | 90
14 | 0 | 0 | 0 | 0 | 0 | 0.2 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0.8 |  |  | 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 | 117.5 | 0 | 0 | 0 | 0 | 94
15 | 0 | 0 | 0 | 0 | 0 | 0.1 | 0 | 0 | 0 | 0 | 0 | 0.6 | 0 | 0 | 0 | 0.3 |  |  | 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 | 119 | 0 | 0 | 0 | 0 | 95.2
16 | 0 | 0 | 0 | 0 | 0 | 16.3 | 0 | 0 | 0 | 0 | 0 | 97.8 | 0 | 0 | 0 | 48.9 |  |  | 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 | 116.5 | 0 | 0 | 0 | 0 | 93.2
17 | 0 | 0 | 0 | 0 | 0 | 41.1 | 0 | 0 | 0 | 0 | 0 | 246.6 | 0 | 0 | 0 | 123.3 |  |  | 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 | 120.5 | 0 | 0 | 0 | 0 | 96.4
18 | 0 | 0 | 0 | 0 | 0 | 41 | 0 | 0 | 0 | 0 | 0 | 246 | 0 | 0 | 0 | 123 |  |  | 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 | 118.5 | 0 | 0 | 0 | 0 | 94.80000000000001
19 | 0 | 14.99883 | 39.9999 | 0 | 0 | 45.3 | 0 | 0 | 0 | 0 | 0 | 216.80127 | 0 | 0 | 0 | 135.9 |  |  | 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 | 111 | 0 | 0 | 0 | 0 | 88.80000000000001
20 | 0 | 15 | 40.00080000000001 | 0 | 0 | 24 | 0 | 0 | 0 | 0 | 0 | 88.9992 | 0 | 0 | 0 | 72 |  |  | 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 | 102.5 | 0 | 0 | 0 | 0 | 82
21 | 0 | 14.99958 | 39.99888 | 0 | 0 | 28.2 | 0 | 0 | 0 | 0 | 0 | 114.20154 | 0 | 0 | 0 | 84.6 |  |  | 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 | 112.5 | 0 | 0 | 0 | 0 | 90
22 | 0 | 15.00012 | 40.00032 | 0 | 0 | 25.8 | 0 | 0 | 0 | 0 | 0 | 99.79956 | 0 | 0 | 0 | 77.39999999999999 |  |  | 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 | 93.5 | 0 | 0 | 0 | 0 | 74.8
23 | 0 | 0 | 0 | 0 | 0 | 27.5 | 0 | 0 | 0 | 0 | 0 | 165 | 0 | 0 | 0 | 82.5 |  |  | 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 | 103.5 | 0 | 0 | 0 | 0 | 82.80000000000001
24 | 0 | 0 | 0 | 0 | 0 | 26.1 | 0 | 0 | 0 | 0 | 0 | 156.6 | 0 | 0 | 0 | 78.3 |  |  | 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 | 103 | 0 | 0 | 0 | 0 | 82.4
25 | 0 | 15.00489 | 30.000123 | 0 | 0 | 26.1 | 0 | 0 | 0 | 0 | 0 | 111.59577 | 0 | 0 | 0 | 78.3 |  |  | 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 | 96 | 0 | 0 | 0 | 0 | 76.80000000000001
26 | 0 | 14.99745 | 30.00075 | 0 | 0 | 19.5 | 0 | 0 | 0 | 0 | 0 | 72.0018 | 0 | 0 | 0 | 58.5 |  |  | 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 | 55 | 0 | 0 | 0 | 0 | 44
27 | 0 | 14.9991 | 30.00075 | 0 | 0 | 25.5 | 0 | 0 | 0 | 0 | 0 | 108.00015 | 0 | 0 | 0 | 76.5 |  |  | 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 | 95.5 | 0 | 0 | 0 | 0 | 76.4
28 | 0 | 0 | 0 | 0 | 0 | 24.9 | 0 | 0 | 0 | 0 | 0 | 149.4 | 0 | 0 | 0 | 74.7 |  |  | 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 | 80.10000000000001 | 0 | 0 | 0 | 0 | 71.2
29 | 0 | 0 | 0 | 0 | 0 | 17.45 | 0 | 0 | 0 | 0 | 0 | 226.85 | 0 | 0 | 0 | 104.7 |  |  | 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 | 81 | 0 | 0 | 0 | 0 | 72
30 | 0 | 15.000484 | 29.999584 | 0 | 0 | 17.3 | 0 | 0 | 0 | 0 | 0 | 179.899932 | 0 | 0 | 0 | 103.8 |  |  | 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 | 64.25999999999999 | 0 | 0 | 0 | 0 | 61.2
31 | 0 | 14.99896 | 30.00105 | 0 | 0 | 31.3 | 0 | 0 | 0 | 0 | 0 | 142.79999 | 0 | 0 | 0 | 93.89999999999999 |  |  | 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 | 73 | 0 | 0 | 0 | 0 | 58.40000000000001