Spreadsheet: 217240d1362007523-populating-a-drop-down-list-dependent-on-multiple-matching-variables-ac-workbook
Sheet: Complete System Comparison

Button House
Ductless Split HVAC Comparison Chart
Configuration: 1 Zone Split System |  | Complete Systems (coolant lines and ancillaries not included)
Make | Model | Type | BTU/h per zone | Efficiency Rating (SEER) | Approx. Electricity Usage (kW) | Warranty | Listed Unit Price | Approx. Wholesale Unit Price
Fujitsu | 9RL | Wall Mounted | 9000 | 20 |  | Compressor: 6 Year / Parts: 2 Year | 1760 | 1380
Fujitsu | 12RLS2 | Wall Mounted | 12000 | 21.5 |  | Compressor: 6 Year / Parts: 2 Year | 1900 | 1590
Fujitsu | 18RLXFW | Wall Mounted | 18000 | 19.2 |  | Compressor: 6 Year / Parts: 2 Year | 2450 | 2050
Fujitsu | 18RCLX | Ceiling Cassette | 18000 | 16 |  | Compressor: 6 Year / Parts: 2 Year | 3640 | 3030
Fujitsu | 24RLXFW | Wall Mounted | 24000 | 18 |  | Compressor: 6 Year / Parts: 2 Year | 2620 | 2180
Fujitsu | 24RCLX | Ceiling Cassette | 24000 | 15 |  | Compressor: 6 Year / Parts: 2 Year | 4140 | 3450
Fujitsu | 30RLX | Wall Mounted | 30000 | 17.5 |  | Compressor: 6 Year / Parts: 2 Year | 3035 | 2530
Fujitsu | 36CLX | Wall Mounted | 36000 | 15 |  | Compressor: 6 Year / Parts: 2 Year | 3800 | 3400
Fujitsu | 36RCLX | Ceiling Cassette | 36000 | 14 |  | Compressor: 6 Year / Parts: 2 Year | 5070 | 4230
LG | LA096HV | Wall Mounted | 9000 | 19 |  | Compressor: 5 Year / Parts: 3 Year | 1800 | 1280
LG | LA126HV | Wall Mounted | 12000 | 18 |  | Compressor: 5 Year / Parts: 3 Year | 2010 | 1400
LG | LA186HV | Wall Mounted | 18000 | 15 |  | Compressor: 5 Year / Parts: 3 Year | 2890 | 1930
LG | LA246HV | Wall Mounted | 24000 | 15.6 |  | Compressor: 5 Year / Parts: 3 Year | 3200 | 2080
LG | LC246HV | Ceiling Cassette | 24000 | 14 |  | Compressor: 5 Year / Parts: 3 Year | 4900 | 3930
LG | LSN306HV | Wall Mounted | 30000 | 15 |  | Compressor: 5 Year / Parts: 3 Year | 2990 | 2600
LG | LG LS360HV | Wall Mounted | 36000 | 16.1 |  | Compressor: 5 Year / Parts: 3 Year | 3990 | 3650
Mitsubishi | [NAME] | Wall Mounted | 9000 | 21 |  | Compressor: 7 Year / Parts: 5 Year | 2000 | 1620
Mitsubishi | MSZ-GE12NA | Wall Mounted | 12000 | 20.5 |  | Compressor: 7 Year / Parts: 5 Year | 2560 | 1790
Mitsubishi | SLZ-KA12NA | Ceiling Cassette | 12000 | 15.4 |  | Compressor: 7 Year / Parts: 5 Year | 3260 | 2330
Mitsubishi | [NAME] | Wall Mounted | 18000 | 19.2 |  | Compressor: 7 Year / Parts: 5 Year | 3300 | 2430
Mitsubishi | MSZ-GE24NA | Wall Mounted | 24000 | 19 |  | Compressor: 7 Year / Parts: 5 Year | 3800 | 2710
Mitsubishi | MSZ-D30NA | Wall Mounted | 30000 | 14.5 |  | Compressor: 7 Year / Parts: 5 Year | 3750 | 3100
Mitsubishi | PUZ-HA30NHA4 | Ceiling Cassette | 30000 | 15.6 |  | Compressor: 7 Year / Parts: 5 Year | 8300 | 7480
Mitsubishi | MSZ-D36NA | Wall Mounted | 36000 | 14.5 |  | Compressor: 7 Year / Parts: 5 Year | 4500 | 3920
Samsung | AQV09NSD | Wall Mounted | 9000 | 19 |  | Compressor: 5 Year / Parts: 3 Year | 2040 | 1409
Samsung | AQV12NSD | Wall Mounted | 12000 | 18 |  | Compressor: 5 Year / Parts: 3 Year | 2240 | 1600
Samsung | AQV18NSD | Wall Mounted | 18000 | 16 |  | Compressor: 5 Year / Parts: 3 Year | 2940 | 2130
Samsung | AQV24NSD | Wall Mounted | 24000 | 15 |  | Compressor: 5 Year / Parts: 3 Year | 3140 | 2240
Samsung | CH070CAV1 | Ceiling Cassette | 24000 | 16 |  | Compressor: 5 Year / Parts: 3 Year | 5000 | 3629
Samsung | AQV36JA | Wall Mounted | 30000 | 18 |  | Compressor: 5 Year / Parts: 3 Year | 4370 | 3330
Samsung | CH105CAV | Ceiling Cassette | 36000 | 16 |  | Compressor: 5 Year / Parts: 3 Year | 6000 | 4320
Configuration: 2 Zone Split System
Make | Model | Type | BTU/h per zone | Efficiency Rating (SEER) | Approx. Electricity Usage (kW) | Warranty | Listed Unit Price | Approx. Wholesale Price
Fujitsu
Fujitsu
Fujitsu
Fujitsu
Fujitsu
Fujitsu
Fujitsu
Fujitsu
Fujitsu
LG
LG
LG
LG
LG
LG
LG
Mitsubishi
Mitsubishi
Mitsubishi
Mitsubishi
Mitsubishi
Mitsubishi
Mitsubishi
Mitsubishi
Samsung
Samsung
Samsung
Samsung
Samsung
Samsung
Samsung
Configuration: 3 Zone Split System
Make | Model | Type | BTU/h per zone | Efficiency Rating (SEER) | Approx. Electricity Usage (kW) | Warranty | Listed Unit Price | Approx. Wholesale Price
Fujitsu
Fujitsu
Fujitsu
Fujitsu
Fujitsu
Fujitsu
Fujitsu
Fujitsu
Fujitsu
LG
LG
LG
LG
LG
LG
LG
Mitsubishi
Mitsubishi
Mitsubishi
Mitsubishi
Mitsubishi
Mitsubishi
Mitsubishi
Mitsubishi
Samsung
Samsung
Samsung
Samsung
Samsung
Samsung
Samsung
Configuration: [NAME]
Make | Model | Type | BTU/h per zone | Efficiency Rating (SEER) | Approx. Electricity Usage (kW) | Warranty | Listed Unit Price | Approx. Wholesale Price
Fujitsu
Fujitsu
Fujitsu
Fujitsu
Fujitsu
Fujitsu
Fujitsu
Fujitsu
Fujitsu
LG
LG
LG
LG
LG
LG
LG
Mitsubishi
Mitsubishi
Mitsubishi
Mitsubishi
Mitsubishi
Mitsubishi
Mitsubishi
Mitsubishi
Samsung
Samsung
Samsung
Samsung
Samsung
Samsung
Samsung