Spreadsheet: 268836d1380842153-changing-the-formula-when-selecting-from-a-drop-down-box-sample-excel-sheet
Sheet: Sheet1

[NAME] | Length | Height | [NAME] | CF/Class | ppd/DHM | ppd-AHAM | Type of Dehumidifier | ppd/DHM | # of DHM
20 | 20 | 8 | 3200 | 32 | 0.5333333333333333 | Class 1 Refrig (Standard)  WTR DHM (60-65) | Phoenix R125  65 ppd  WTR DHM | 0.5333333333333333 | 1
60 | 20 | 8 | 9600 | 96 | 1.371428571428571 | Class 1 Refrig (Gas Bypass) Drizair  WTR DHM> (70-92) | [NAME]  70 ppd  WTE DHM> | 1.371428571428571 | 2
15 | 30 | 7 | 3150 | 31.5 | 0.2863636363636364 | Class 1 Refrig (GAS Bypass) Drizair  WTR DHM>> (110-135) | LGR 2000  110 ppd WTR DHM>> | 0.2863636363636364 | 1
17 | 30 | 8 | 4080 | 40.8 | 0.24 | Class 1 Refrig (GAS Bypass) Drizair  WTR DHM>>> (170-176) | Phoenix 300  176 ppd  WTR DHM>>> | 0.24 | 1
200 | 20 | 16 | 64000 | 1600 | 26.66666666666667 | Class 2 Refrig (Standard)  WTR DHM (60-65) | Drizair 1200  60 ppd  WRT DHM | 26.66666666666667 | 27
17 | 30 | 8 | 4080 | 81.6 | 1.165714285714286 | Class 2 Refrig (Gas Bypass)  WTR DHM> (70-92) | [NAME]  70 ppd  WTE DHM> | 1.165714285714286 | 2
17 | 30 | 8 | 4080 | 81.6 | 0.7418181818181818 | Class 2 Refrig (Gas Bypass)  WTR DHM>> (110-135) | LGR 2000  110 ppd WTR DHM>> | 0.7418181818181818 | 1
17 | 30 | 8 | 4080 | 81.6 | 0.48 | Class 2 Refrig (Gas Bypass)  WTR DHM>>> (170-176) | LGR 3500i  170 ppd  WTR DHM>>> | 0.48 | 1
17 | 30 | 8 | 4080 | 136 | 2.266666666666667 | Class 3 Refrig (Standard) WTR DHM (60-65) | Drizair 1200  60 ppd  WRT DHM | 2.266666666666667 | 3
15 | 30 | 8 | 3600 | 90 | 1.285714285714286 | Class 3 Refrig (Gas Bypass) WTR DHM> (70-92) | [NAME]  70 ppd  WTE DHM> | 1.285714285714286 | 2
23 | 47 | 8 | 8648 | 216.2 | 1.965454545454545 | Class 3 Refrig (Gas Bypass) WTR DHM>> (110-135) | LGR 2000  110 ppd WTR DHM>> | 1.965454545454545 | 2
17 | 30 | 8 | 4080 | 102 | 0.6 | Class 3 Refrig ([NAME]) WTR DHM>>> (170-176) | Phoenix R200  125 ppd  WTR DHM>> | 0.6 | 1
17 | 30 | 8 | 4080 | N/A | N/A | Class 4 Refrig (Standard) (60-65) | Drizair 1200  60 ppd  WRT DHM | N/A
17 | 30 | 8 | 4080 | 81.6 | 1.165714285714286 | Class 4 Refrig (Gas Bypass)WTR DHM> (70-92) | [NAME]  70 ppd  WTE DHM> | 1.165714285714286 | 2
17 | 30 | 8 | 4080 | 81.6 | 0.7418181818181818 | Class 4 Refrig (Gas Bypass) WTR DHM>> (110-135) | LGR 7000LXi  130 ppd WTR DHM>> | 0.7418181818181818 | 1
17 | 30 | 8 | 4080 | 81.6 | 0.48 | Class 4 Refrig ([NAME]) WTR DHM>>> (170-176) | Phoenix 270 HTx  161 ppd  WTR DHM>>> | 0.48 | 1
 |  |  | 2500 | 25 | 0.4166666666666667 | Class 1 Refrig (Standard)  WTR DHM (60-65) | Drizair 1200  60 ppd  WRT DHM | 0.4166666666666667 | 1
 |  |  | 9488 | 94.88 | 1.355428571428571 | Class 1 Refrig (Gas Bypass) Drizair  WTR DHM> (70-92) | [NAME]  70 ppd  WTE DHM> | 1.355428571428571 | 2
 |  |  | 9099 | 90.99 | 0.8271818181818181 | Class 1 Refrig (GAS Bypass) Drizair  WTR DHM>> (110-135) | LGR 7000LXi  130 ppd WTR DHM>> | 0.8271818181818181 | 1
 |  |  | 2500 | 25 | 0.1470588235294118 | Class 1 Refrig (GAS Bypass) Drizair  WTR DHM>>> (170-176) | Phoenix 270 HTx  161 ppd  WTR DHM>>> | 0.1470588235294118 | 1
 |  |  | 2500 | 62.5 | 0.4166666666666667 | Class 2 Refrig (Standard)  WTR DHM (60-65) | Drizair 1200  60 ppd  WRT DHM | 0.4166666666666667 | 1
 |  |  | 2500 | 50 | 1.355428571428571 | Class 2 Refrig (Gas Bypass)  WTR DHM> (70-92) | [NAME]  70 ppd  WTE DHM> | 1.355428571428571 | 2
 |  |  | 8794.73 | 175.8946 | 0.8625454545454545 | Class 2 Refrig (Gas Bypass)  WTR DHM>> (110-135) | LGR 2800i  130 ppd WTR DHM>> | 0.8625454545454545 | 1
 |  |  | 2500 | 50 | 0.535235294117647 | Class 2 Refrig (Gas Bypass)  WTR DHM>>> (170-176) | Phoenix 300  176 ppd  WTR DHM>>> | 0.535235294117647 | 1
 |  |  | 2500 | 83.33333333333333 | 1.388888888888889 | Class 3 Refrig (Standard) WTR DHM (60-65) | Drizair 1200  60 ppd  WRT DHM | 1.388888888888889 | 2
 |  |  | 9096 | 227.4 | 3.248571428571429 | Class 3 Refrig (Gas Bypass) WTR DHM> (70-92) | [NAME]  70 ppd  WTE DHM> | 3.248571428571429 | 4
 |  |  | 9099 | 227.475 | 2.067954545454545 | Class 3 Refrig (Gas Bypass) WTR DHM>> (110-135) | LGR 2800i  130 ppd WTR DHM>> | 2.067954545454545 | 3
 |  |  | 2500 | 62.5 | 0.3676470588235294 | Class 3 Refrig ([NAME]) WTR DHM>>> (170-176) | LGR 3500i  170 ppd  WTR DHM>>> | 0.3676470588235294 | 1
 |  |  | 2500 | N/A | N/A | Class 4 Refrig (Standard) (60-65) |  | N/A
 |  |  | 12500 | 250 | 3.571428571428572 | Class 4 Refrig (Gas Bypass)WTR DHM> (70-92) | [NAME]  70 ppd  WTE DHM> | 3.571428571428572 | 4
 |  |  | 2500 | 50 | 0.4545454545454545 | Class 4 Refrig (Gas Bypass) WTR DHM>> (110-135) | LGR 2000  110 ppd WTR DHM>> | 0.4545454545454545 | 1
 |  |  | 2500 | 50 | 0.2941176470588235 | Class 4 Refrig ([NAME]) WTR DHM>>> (170-176) | LGR 3500i  170 ppd  WTR DHM>>> | 0.2941176470588235 | 1