Spreadsheet: 217240d1362007523-populating-a-drop-down-list-dependent-on-multiple-matching-variables-ac-workbook
Sheet: Indoor Unit Details

Wall Mounted Heat Pumpts
Make | Model | BTU/h | Best Warranty Found | Multi-Zone Compatible? | Voltage | Min Amperage | Sound at Speed (dB) | Lowest Unit Price Found
Fujitsu | ASU9RLF | 9000 | Compressor: 7 Year / Parts: 5 Year | Y |  |  |  | 545.95
Fujitsu | ASU9RLS | 9000 | Compressor: 7 Year / Parts: 5 Year | N |  |  |  | 595.95
Fujitsu | ASU12RLF | 12000 | Compressor: 7 Year / Parts: 5 Year | Y |  |  |  | 591.95
Fujitsu | ASU15RLS | 15000 | Compressor: 7 Year / Parts: 5 Year | N |  |  |  | 691.95
Fujitsu | ASU18RLF | 18000 | Compressor: 7 Year / Parts: 5 Year | Y |  |  |  | 858.95
Fujitsu | ASU24RLF | 24000 | Compressor: 7 Year / Parts: 5 Year | Y |  |  |  | 909.95
Fujitsu | ASU30RLX | 30600 | Compressor: 7 Year / Parts: 5 Year | N |  |  |  | 1035.95
LG | LMN096HVT | 9000 | Compressor: 5 Year/ Parts: 2 Year | Y |  |  |  | 462.95
LG | LMN126HVT | 12000 | Compressor: 5 Year/ Parts: 2 Year | Y |  |  |  | 503.95
LG | LMN186HVT | 18000 | Compressor: 5 Year/ Parts: 2 Year | Y |  |  |  | 742.95
LG | LMAN096HVT Mirror Finish | 9000 | Compressor: 5 Year/ Parts: 2 Year | Y |  |  |  | 517.95
LG | LMAN126HVT Mirror Finish | 12000 | Compressor: 5 Year/ Parts: 2 Year | Y |  |  |  | 567.95
LG | LMAN186HVT Mirror Finish | 18000 | Compressor: 5 Year/ Parts: 2 Year | Y |  |  |  | 835.95
Mitsubishi | MSZ-GE06NA-8 | 6000 | Compressor: 7 Year / Parts: 5 Year | Y |  |  |  | 507.95
Mitsubishi | MSZ-GE09NA-8 | 9000 | Compressor: 7 Year / Parts: 5 Year | Y |  |  |  | 558.95
Mitsubishi | MSZ-FE09NA-8 | 9000 | Compressor: 7 Year / Parts: 5 Year | Y |  |  |  | 601.95
Mitsubishi | MSZ-GE12NA-8 | 12000 | Compressor: 7 Year / Parts: 5 Year | Y |  |  |  | 660.95
Mitsubishi | MSZ-FE12NA-8 | 12000 | Compressor: 7 Year / Parts: 5 Year | Y |  |  |  | 707.95
Mitsubishi | MSZ-GE15NA-8 | 15000 | Compressor: 7 Year / Parts: 5 Year | Y |  |  |  | 801.95
Mitsubishi | MSZ-GE18NA-8 | 18000 | Compressor: 7 Year / Parts: 5 Year | Y |  |  |  | 835.95
Mitsubishi | [NAME]-FE18NA | 22500 | Compressor: 7 Year / Parts: 5 Year | N |  |  |  | 933.95
Mitsubishi | MSZ-GE24NA | 24000 | Compressor: 7 Year / Parts: 5 Year | Y |  |  |  | 903.95
Samsung | MH026FNCA | 9000 | Compressor: 5 Year / Parts: 3 Year | Y |  |  |  | 659.95
Samsung | AQV09NSDN | 9000 | Compressor: 5 Year / Parts: 3 Year | N |  |  |  | 649.99
Samsung | MH035FNCA | 12000 | Compressor: 5 Year / Parts: 3 Year | Y |  |  |  | 725.95
Samsung | AQV12NSDN | 12000 | Compressor: 5 Year / Parts: 3 Year | N |  |  |  | 729.99
Samsung | AQV12VBE Mirror Finish | 12000 | Compressor: 5 Year / Parts: 3 Year | N |  |  |  | 779.99
Samsung | MH052FNCA | 18000 | Compressor: 5 Year / Parts: 3 Year | Y |  |  |  | 890.95
Samsung | AQV18NSDN | 18000 | Compressor: 5 Year / Parts: 3 Year | N |  |  |  | 939.95
Samsung | AQV18VBE Mirror Finish | 18000 | Compressor: 5 Year / Parts: 3 Year | N |  |  |  | 969.95
Samsung | AQV24NSDN | 24000 | Compressor: 5 Year / Parts: 3 Year | N |  |  |  | 1019.99
Samsung | AQV24VBE Mirror Finish | 24000 | Compressor: 5 Year / Parts: 3 Year | N |  |  |  | 1049.99
Samsung | AQV36JA | 36000 | Compressor: 5 Year / Parts: 3 Year | N |  |  |  | 1419.99
Ceiling Cassette Heat Pumps
Make | Model | BTU/h | Best Warranty Found | Multi-Zone Compatible? | Voltage | Min Amperage | Sound at Speed (dB) | Lowest Unit Price Found
Fujitsu | AUU9RLF | 9000 | Compressor: 7 Year / Parts: 5 Year | Y |  |  |  | 712.95
Fujitsu | AUU9RML Halcyon | 9000 | Compressor: 7 Year / Parts: 5 Year | Y |  |  |  | 770.95
Fujitsu | AUU12RLF | 12000 | Compressor: 7 Year / Parts: 5 Year | Y |  |  |  | 809.95
Fujitsu | AUU12RML Halcyon | 12000 | Compressor: 7 Year / Parts: 5 Year | Y |  |  |  | 875.95
Fujitsu | AUU18RLF | 18000 | Compressor: 7 Year / Parts: 5 Year | Y |  |  |  | 1077.95
Fujitsu | AUU18RML Halcyon | 18000 | Compressor: 7 Year / Parts: 5 Year | Y |  |  |  | 1205.95
Fujitsu | AUU24RCLX | 24000 | Compressor: 6 Year / Parts: 2 Year | N |  |  |  | 1655.99
Fujitsu | AUU36RCLX | 36000 | Compressor: 6 Year / Parts: 2 Year | N |  |  |  | 2064.46
Fujitsu | AUU42RCLX | 42700 | Compressor: 6 Year / Parts: 2 Year | N |  |  |  | 2309.46
LG | LMCN125HV | 12000 | Compressor: 5 Year/ Parts: 2 Year | Y |  |  |  | 642.95
LG | LMCN185HV | 18000 | Compressor: 5 Year/ Parts: 2 Year | Y |  |  |  | 882.95
Mitsubishi | SLZ-KA09NA.TH | 9000 | Compressor: 7 Year / Parts: 5 Year | Y |  |  |  | 1035.95
Mitsubishi | SLZ-KA12NA.TH | 12000 | Compressor: 7 Year / Parts: 5 Year | Y |  |  |  | 1180.95
Mitsubishi | SLZ-KA15NA.TH | 15000 | Compressor: 7 Year / Parts: 5 Year | Y |  |  |  | 1410.95
Mitsubishi | PLA-A18BA4 | 18000 | Compressor: 7 Year / Parts: 5 Year | Y |  |  |  | 1878.95
Mitsubishi | PLA-A24BA4 | 24000 | Compressor: 7 Year / Parts: 5 Year | Y |  |  |  | 2175.95
Mitsubishi | PLA-A30BA4 | 30000 | Compressor: 7 Year / Parts: 5 Year | Y |  |  |  | 2601.95
Mitsubishi | PLA-A36BA4 | 36000 | Compressor: 7 Year / Parts: 5 Year | N |  |  |  | 2920.95
Mitsubishi | PLA-A42BA4 | 42000 | Compressor: 7 Year / Parts: 5 Year | Y |  |  |  | 3226.95
Samsung | CH070CAV1 | 24000 | Compressor: 5 Year / Parts: 3 Year | N |  |  |  | 1979.99
Samsung | CH105CAV | 36000 | Compressor: 5 Year / Parts: 3 Year | N |  |  |  | 2009.99
Samsung | CH140CAV | 48000 | Compressor: 5 Year / Parts: 3 Year | N |  |  |  | 2119.99
Concealed Ceiling Mini Duct Heat Pumps
Make | Model | BTU/h | Best Warranty Found | Multi-Zone Compatible? | Voltage | Min Amperage | Sound at Speed (dB) | Lowest Unit Price Found
Fujitsu | ARU9RLF | 9000 | Compressor: 7 Year / Parts: 5 Year | Y |  |  |  | 749.95
Fujitsu | ARU9RML Halcyon | 9000 | Compressor: 7 Year / Parts: 5 Year | Y |  |  |  | 790.95
Fujitsu | ARU12RLF | 12000 | Compressor: 7 Year / Parts: 5 Year | Y |  |  |  | 771.95
Fujitsu | [NAME] | 12000 | Compressor: 7 Year / Parts: 5 Year | Y |  |  |  | 819.95
Fujitsu | ARU18RLF | 18000 | Compressor: 7 Year / Parts: 5 Year | Y |  |  |  | 963.95
Fujitsu | ARU18RML Halcyon | 18000 | Compressor: 7 Year / Parts: 5 Year | Y |  |  |  | 1020.95
Fujitsu | ARU24RLF | 24000 | Compressor: 7 Year / Parts: 5 Year | Y |  |  |  | 1218.95
LG | LMDN095HV | 9000 | Compressor: 5 Year/ Parts: 2 Year | Y |  |  |  | 600.95
LG | LMDN125HV | 12000 | Compressor: 5 Year/ Parts: 2 Year | Y |  |  |  | 618.95
LG | LMDN185HV | 18000 | Compressor: 5 Year/ Parts: 2 Year | Y |  |  |  | 790.95
Mitsubishi | SEZ-KD09NA4.TH | 9000 | Compressor: 7 Year / Parts: 5 Year | Y |  |  |  | 912.95
Mitsubishi | SEZ-KD12NA4.TH | 12000 | Compressor: 7 Year / Parts: 5 Year | Y |  |  |  | 984.95
Mitsubishi | SEZ-KD15NA4.TH | 15000 | Compressor: 7 Year / Parts: 5 Year | Y |  |  |  | 1138.95
Mitsubishi | SEZ-KD18NA4.TH | 18000 | Compressor: 7 Year / Parts: 5 Year | Y |  |  |  | 1278.95
Mitsubishi | PEAD-A24AA4 | 24000 | Compressor: 7 Year / Parts: 5 Year | Y |  |  |  | 1845.95
Mitsubishi | PEAD-A30AA4 | 30000 | Compressor: 7 Year / Parts: 5 Year | N |  |  |  | 2093.95
Mitsubishi | PEAD-A36AA4 | 36000 | Compressor: 7 Year / Parts: 5 Year | N |  |  |  | 2342.95
Mitsubishi | PEAD-A42AA4 | 42000 | Compressor: 7 Year / Parts: 5 Year | N |  |  |  | 2675.95
Samsung | MH026FECA | 9000 | Compressor: 5 Year / Parts: 3 Year | Y |  |  |  | 824.95
Samsung | MH035FECA | 12000 | Compressor: 5 Year / Parts: 3 Year | Y |  |  |  | 890.95
Samsung | MH052FECA | 18000 | Compressor: 5 Year / Parts: 3 Year | Y |  |  |  | 1055.95
Samsung | EH070CAV | 24000 | Compressor: 5 Year / Parts: 3 Year | N |  |  |  | 979.99