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

Make | Model | BTU/h | [NAME] | Efficiency Rating (SEER) | Max Power Consumption (kW) | Voltage | Min Amperage | [NAME] Output (dB) | Best Warranty Found | Lowest Unit Price Found
Fujitsu | AOU9RLFW | 9000 | 1 | 23 |  |  |  |  | Compressor: 7 Year / Parts: 5 Year | 889.95
Fujitsu | AOU9RLS Halcyon | 9000 | 1 | 26 |  |  |  |  | Compressor: 7 Year / Parts: 5 Year | 908.95
Fujitsu | AOU9RLS2 | 9000 | 1 | 27.2 |  |  |  |  | Compressor: 7 Year / Parts: 5 Year | 967.93
Fujitsu | AOU12RLFW | 12000 | 1 | 21 |  |  |  |  | Compressor: 7 Year / Parts: 5 Year | 903.95
Fujitsu | AOU12RLS2 | 12000 | 1 | 25 |  |  |  |  | Compressor: 7 Year / Parts: 5 Year | 1036.8
Fujitsu | AOU15RLS Halcyon | 15000 | 1 | 21 |  |  |  |  | Compressor: 7 Year / Parts: 5 Year | 1052.95
Fujitsu | AOU18RLXFZ | 18000 | 2 | 18 |  |  |  |  | Compressor: 7 Year / Parts: 5 Year | 1424.95
Fujitsu | AOU18RLXFW Halcyon | 18000 | 1 | 19.2 |  |  |  |  | Compressor: 7 Year / Parts: 5 Year | 1251.95
Fujitsu | [NAME] | 24000 | 2 | 18 |  |  |  |  | Compressor: 7 Year / Parts: 5 Year | 1341.95
Fujitsu | AOU24RLXFZ | 24000 | 4 | 18 |  |  |  |  | Compressor: 7 Year / Parts: 5 Year | 1596.95
Fujitsu | AOU30RLX Halcyon | 30000 | 1 | 17 |  |  |  |  | Compressor: 7 Year / Parts: 5 Year | 1568.95
Fujitsu | AOU36RLXFZ | 36000 | 4 | 16 |  |  |  |  | Compressor: 7 Year / Parts: 5 Year | 2391.95
Fujitsu | AOU48RLXFZ | 48000 | 8 | 17 |  |  |  |  | Compressor: 7 Year / Parts: 5 Year | 2735.95
LG | LMU187HV | 18000 | 2 | 21 |  |  |  |  | Compressor: 5 Year/ Parts: 2 Year | 1260.95
LG | LMU247HV | 24000 | 3 | 21.7 |  |  |  |  | Compressor: 5 Year/ Parts: 2 Year | 1429.95
LG | LMU369HV | 36000 | 4 | 17.5 |  |  |  |  | Compressor: 5 Year/ Parts: 2 Year | 2178.95
LG | LMU540HV | 54000 | 8 | 18 |  |  |  |  | Compressor: 7 Year / Parts: 5 Year | 2990.95
Mitsubishi | MXZ-2B20NA-1 | 20000 | 2 | 18 |  |  |  |  | Compressor: 7 Year / Parts: 5 Year | 1862.95
Mitsubishi | MXZ-3B24NA-1 | 24000 | 3 | 17.5 |  |  |  |  | Compressor: 7 Year / Parts: 5 Year | 2383.95
Mitsubishi | MXZ-3B30NA-1 | 30000 | 3 | 17.5 |  |  |  |  | Compressor: 7 Year / Parts: 5 Year | 2680.95
Mitsubishi | MXZ-4B36NA-1 | 36000 | 4 | 18 |  |  |  |  | Compressor: 7 Year / Parts: 5 Year | 2992.95
Mitsubishi | MXZ-8B48NA-1 | 48000 | 8 | 15 |  |  |  |  | Compressor: 7 Year / Parts: 5 Year | 3968.95
Samsung | AQV09NSDX | 9000 | 1 | 19 |  |  |  |  | Compressor: 5 Year / Parts: 3 Year | 939.99
Samsung | AQV12NSDX | 12000 | 1 | 18 |  |  |  |  | Compressor: 5 Year / Parts: 3 Year | 1059.99
Samsung | AQV18NSDX | 18000 | 1 | 17 |  |  |  |  | Compressor: 5 Year / Parts: 3 Year | 1369.99
Samsung | AQV24NSDX | 24000 | 1 | 15 |  |  |  |  | Compressor: 5 Year / Parts: 3 Year | 1499.99
Samsung | MH050FXCA2A | 24000 | 2 | 16 |  |  |  |  | Compressor: 5 Year / Parts: 3 Year | 1709.99
Samsung | AQV36JAX | 36000 | 1 | 18 |  |  |  |  | Compressor: 5 Year / Parts: 3 Year | 2089.95
Samsung | MH080FXCA4A | 36000 | 3 | 16 |  |  |  |  | Compressor: 5 Year / Parts: 3 Year | 2419.99
Samsung | UH140CAV | 48000 | 1 | 14.8 |  |  |  |  | Compressor: 5 Year / Parts: 3 Year | 2769.95