Spreadsheet: 844583d1696350107-creating-a-table-with-variable-values-based-on-dropdown-selection-copy-of-sample-data-stdar2-
Sheet: Sheet2

 |  |  |  |  |  |  |  |  | Creating a table with variable values based on dropdown selection (excelforum.com)
 |  | APLO |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Material | Porcelin | The table values would change based on the drop down selections
 | Demand Plan |  | Q1 | Q2 | Q3 | Q4 | Total |  |  |  | Dibber | HappT | MicroSit | ProductD | Total |  |  | Vendor | Dibber
 |  | USA | 8 | 10 | 11 | 12.1 |  |  |  | Candle | 2.8 |  |  |  |  |  |  | Type | ANP 3.0
 |  | Canada | 16 | 20 | 22 | 24.2 |  |  |  | Porcelin | 50
 |  | ALAC | 32 | 40 | 44 | 48.40000000000001 |  |  |  | Perform | 145 |  |  |  |  |  |  |  | Q1 | Q2 | Q3 | Q4
 |  | Greater China | 64 | 80 | 88 | 96.80000000000001 |  |  |  | Maynard |  |  |  |  |  |  |  | USA
 |  | EMEIA(Includes India) | 128 | 160 | 176 | 193.6 |  |  |  | Alpine |  |  |  |  |  |  |  | CANADA
 |  | Japan | 256 | 320 | 352 | 387.2 |  |  |  | Beero |  |  |  |  |  |  |  | Mexico
 |  | South Korea | 512 | 640 | 704 | 774.4000000000001 |  |  |  | Hefty
 |  | ANZ | 1024 | 1280 | 1408 | 1548.8 |  |  |  |  |  |  |  |  |  |  |  | Note that Mexico isn't listed in column C
 |  | SEA | 2048 | 2560 | 2816 | 3097.6
 |  | ANP 3.0
 |  |  | Q1 | Q2 | Q3 | Q4 | Total |  |  |  | Dibber | HappT | MicroSit | ProductD | Total
 |  | USA | 16 | 20 | 22 | 24.2 |  |  |  | Candle | 1.4 | 1.9 | 2.4 | 2.9
 |  | Canada | 8 | 10 | 11 | 12.1 |  |  |  | Porcelin | 25 | 25.5 | 26 | 26.5
 |  | ALAC | 64 | 80 | 88 | 96.80000000000001 |  |  |  | Perform | 72.5 | 73 | 73.5 | 74
 |  | Greater China | 32 | 40 | 44 | 48.40000000000001 |  |  |  | Maynard | 2.8 | 3.8 | 4.8 | 5.8
 |  | EMEIA(Includes India) | 256 | 320 | 352 | 387.2 |  |  |  | Alpine | 50 | 51 | 52 | 53
 |  | Japan | 128 | 160 | 176 | 193.6 |  |  |  | Beero | 145 | 146 | 147 | 148
 |  | South Korea | 1024 | 1280 | 1408 | 1548.8 |  |  |  | Hefty | 5.6 | 7.6 | 9.6 | 11.6
 |  | ANZ | 512 | 640 | 704 | 774.4000000000001
 |  | SEA | 4096 | 5120 | 5632 | 6195.200000000001
 |  | Cross Shop
 |  |  | Q1 | Q2 | Q3 | Q4 | Total |  |  |  | Dibber | HappT | MicroSit | ProductD | Total
 |  | USA | 32 | 40 | 44 | 48.40000000000001 |  |  |  | Candle | 0.7 | 0.95 | 1.2 | 1.45
 |  | Canada | 4 | 5 | 5.5 | 6.050000000000001 |  |  |  | Porcelin | 12.5 | 12.75 | 13 | 13.25
 |  | ALAC | 128 | 160 | 176 | 193.6 |  |  |  | Perform | 36.25 | 36.5 | 36.75 | 37
 |  | Greater China | 16 | 20 | 22 | 24.2 |  |  |  | Maynard | 1.4 | 1.9 | 2.4 | 2.9
 |  | EMEIA(Includes India) | 512 | 640 | 704 | 774.4000000000001 |  |  |  | Alpine | 25 | 25.5 | 26 | 26.5
 |  | Japan | 64 | 80 | 88 | 96.80000000000001 |  |  |  | Beero | 72.5 | 73 | 73.5 | 74
 |  | South Korea | 2048 | 2560 | 2816 | 3097.6 |  |  |  | Hefty | 2.8 | 3.8 | 4.8 | 5.8
 |  | ANZ | 256 | 320 | 352 | 387.2
 |  | SEA | 8192 | 10240 | 11264 | 12390.4
 |  | Next Level Cross Shop
 |  |  | Q1 | Q2 | Q3 | Q4 | Total |  |  |  | Dibber | HappT | MicroSit | ProductD | Total
 |  | USA | 64 | 80 | 88 | 96.80000000000001 |  |  |  | Candle | 3.5 | 4.75 | 6 | 7.25
 |  | Canada | 2 | 2.5 | 2.75 | 3.025 |  |  |  | Porcelin | 62.5 | 63.75 | 65 | 66.25
 |  | ALAC | 256 | 320 | 352 | 387.2 |  |  |  | Perform | 181.25 | 182.5 | 183.75 | 185
 |  | Greater China | 8 | 10 | 11 | 12.1 |  |  |  | Maynard | 7 | 9.5 | 12 | 14.5
 |  | EMEIA(Includes India) | 1024 | 1280 | 1408 | 1548.8 |  |  |  | Alpine | 125 | 127.5 | 130 | 132.5
 |  | Japan | 32 | 40 | 44 | 48.40000000000001 |  |  |  | Beero | 362.5 | 365 | 367.5 | 370
 |  | South Korea | 4096 | 5120 | 5632 | 6195.200000000001 |  |  |  | Hefty | 14 | 19 | 24 | 29
 |  | ANZ | 128 | 160 | 176 | 193.6
 |  | SEA | 16384 | 20480 | 22528 | 24780.8