Spreadsheet: 124255d1318270612-excel-2007-forumating-from-drop-down-boxes-domestic-quote_vlookup-example
Sheet: System To Install

COMBI BOILER |  |  |  |  |  |  |  |  | TRADITIONAL SYSTEM BOILER |  |  |  |  |  |  |  |  | HEAT PUMP
 | Price | SL No | Notes | Total | Value | Labour | Total Labour |  |  | Price | SL No | Notes | Total | Value | Labour | Total Labour |  |  | Price | SL No | Notes | Total | Value | Labour | Total Labour
Combination Boiler | 0 |  |  | 0 | 0 |  |  |  | System Boiler | 0 |  |  | 0 | 0 |  |  |  | Heat Pump | 0 |  |  | 0 | 0
[NAME] | 0 |  |  | 0 | 0 |  |  |  | [NAME] |  |  |  | 0 | 0 |  |  |  | [NAME] | 0 |  |  | 0 | 0
Flue Bend 90 | 0 |  |  | 0 | 0 |  |  |  | Flue Bend 90 | 0 |  |  | 0 | 0 |  |  |  | Flue Bend 90 | 0 |  |  | 0 | 0
Flue Extension | 0 |  |  | 0 | 0 |  |  |  | Flue Extension | 0 |  |  | 0 | 0 |  |  |  | Flu Extension | 0 |  |  | 0 | 0
Flue Roof/Tile Connection | 0 |  |  | 0 | 0 |  |  |  | Flue Roof/Tile Connection | 0 |  |  | 0 | 0 |  |  |  | Flue Roof/Tile Connection | 0 |  |  | 0 | 0
External Flue Basket | 0 |  |  | 0 | 0 |  |  |  | External Flue Basket | 0 |  |  | 0 | 0 |  |  |  | External Flue Basket | 0 |  |  | 0 | 0
[NAME] | 0 |  |  | 0 | 0 |  |  |  | Pump | 0 |  |  | 0 | 0 |  |  |  | Pump | 0 |  |  | 0 | 0
Pump | 0 |  |  | 0 | 0 |  |  |  | 22 mm Pump Valves | 0 |  |  | 0 | 0 |  |  |  | 22 mm Pump Valves | 0 |  |  | 0 | 0
22 mm Pump Valves | 0 |  |  | 0 | 0 |  |  |  | Two Port Valve | 0 |  |  | 0 | 0 |  |  |  | Two Port Valve | 0 |  |  | 0 | 0
Two Port Valve | 0 |  |  | 0 | 0 |  |  |  | [NAME] | 0 |  |  | 0 | 0 |  |  |  | [NAME] | 0 |  |  | 0 | 0
[NAME] | 0 |  |  | 0 | 0 |  |  |  | Automatic Air Vent | 0 |  |  | 0 | 0 |  |  |  | Automatic Air Vent | 0 |  |  | 0 | 0
Automatic Air Vent | 0 |  |  | 0 | 0 |  |  |  | Automatic By pass | 0 |  |  | 0 | 0 |  |  |  | Automatic By pass | 0 |  |  | 0 | 0
Automatic By pass | 0 |  |  | 0 | 0 |  |  |  | 22 mm Gate Valve | 0 |  |  | 0 | 0 |  |  |  | 22 mm Gate Valve | 0 |  |  | 0 | 0
22 mm Gate Valve | 0 |  |  | 0 | 0 |  |  |  | 18 Litre Pressure Vessel | 0 |  |  | 0 | 0 |  |  |  | 18 Litre Pressure Vessel | 0 |  |  | 0 | 0
18 Litre Pressure Vessel | 0 |  |  | 0 | 0 |  |  |  | 18 Litre Pressure Vessel Kit | 0 |  |  | 0 | 0 |  |  |  | 18 Litre Pressure Vessel Kit | 0 |  |  | 0 | 0
18 Litre Pressure Vessel Kit | 0 |  |  | 0 | 0 |  |  |  | Pressure Vessel Bracket | 0 |  |  | 0 | 0 |  |  |  | Pressure Vessel Bracket | 0 |  |  | 0 | 0
Pressure Vessel Bracket | 0 |  |  | 0 | 0 |  |  |  | 15 x 22 mm Tun dish | 0 |  |  | 0 | 0 |  |  |  | 15 x 22 mm Tun dish | 0 |  |  | 0 | 0
15 x 22 mm Tun dish | 0 |  |  | 0 | 0 |  |  |  | [NAME] | 0 |  |  | 0 | 0 |  |  |  | [NAME] | 0 |  |  | 0 | 0
[NAME] | 0 |  |  | 0 | 0 |  |  |  | Pressure Reducing Valve 22 mm | 0 |  |  | 0 | 0 |  |  |  | Pressure Reducing Valve 22 mm | 0 |  |  | 0 | 0
Pressure Reducing Valve 22 mm | 0 |  |  | 0 | 0 |  |  |  | Stop Tap 25 / 22 mm | 0 |  |  | 0 | 0 |  |  |  | Stop Tap 25 / 22 mm | 0 |  |  | 0 | 0
Stop Tap 25 / 22 mm | 0 |  |  | 0 | 0 |  |  |  | 22 mm Servive Valve | 0 |  |  | 0 | 0 |  |  |  | 22 mm Servive Valve | 0 |  |  | 0 | 0
22 mm Servive Valve | 0 |  |  | 0 | 0 |  |  |  | 15 mm Service Valve | 0 |  |  | 0 | 0 |  |  |  | 15 mm Service Valve | 0 |  |  | 0 | 0
15 mm Service Valve | 0 |  |  | 0 | 0 |  |  |  | 15 mm Tap Con Service Valve Straight | 0 |  |  | 0 | 0 |  |  |  | 15 mm Tap Con Service Valve Straight | 0 |  |  | 0 | 0
15 mm Tap Con Service Valve Straight | 0 |  |  | 0 | 0 |  |  |  | 15 mm Tap Con Service Valve Bent | 0 |  |  | 0 | 0 |  |  |  | 15 mm Tap Con Service Valve Bent | 0 |  |  | 0 | 0
15 mm Tap Con Service Valve Bent | 0 |  |  | 0 | 0 |  |  |  | 15 mm Gas Cock | 0 |  |  | 0 | 0 |  |  |  | 15 mm Gas Cock | 0 |  |  | 0 | 0
15 mm Gas Cock | 0 |  |  | 0 | 0 |  |  |  | 15 mm Soldered Drain Off Valve | 0 |  |  | 0 | 0 |  |  |  | 15 mm Soldered Drain Off Valve | 0 |  |  | 0 | 0
15 mm Soldered Drain Off Valve | 0 |  |  | 0 | 0 |  |  |  | Gas Ball Valve 22 mm | 0 |  |  | 0 | 0 |  |  |  | Gas Ball Valve 22 mm | 0 |  |  | 0 | 0
Gas Ball Valve 22 mm | 0 |  |  | 0 | 0 |  |  |  | 32 mm P Trap | 0 |  |  | 0 | 0 |  |  |  | 32 mm P Trap | 0 |  |  | 0 | 0
32 mm P Trap | 0 |  |  | 0 | 0 |  |  |  | 32 mm S Trap | 0 |  |  | 0 | 0 |  |  |  | 32 mm S Trap | 0 |  |  | 0 | 0
32 mm S Trap | 0 |  |  | 0 | 0 |  |  |  | 32 mm [NAME] | 0 |  |  | 0 | 0 |  |  |  | 32 mm [NAME] | 0 |  |  | 0 | 0
32 mm [NAME] | 0 |  |  | 0 | 0 |  |  |  | 40 mm P Trap | 0 |  |  | 0 | 0 |  |  |  | 40 mm P Trap | 0 |  |  | 0 | 0
40 mm P Trap | 0 |  |  | 0 | 0 |  |  |  | 40 mm S Trap | 0 |  |  | 0 | 0 |  |  |  | 40 mm S Trap | 0 |  |  | 0 | 0
40 mm S Trap | 0 |  |  | 0 | 0 |  |  |  | 40 mm [NAME] | 0 |  |  | 0 | 0 |  |  |  | 40 mm [NAME] | 0 |  |  | 0 | 0
40 mm [NAME] | 0 |  |  | 0 | 0 |  |  |  | [NAME] | 0 |  |  | 0 | 0 |  |  |  | [NAME] | 0 |  |  | 0 | 0
[NAME] | 0 |  |  | 0 | 0 |  |  |  | Straight Pan Connector | 0 |  |  | 0 | 0 |  |  |  | Straight Pan Connector | 0 |  |  | 0 | 0
Straight Pan Connector | 0 |  |  | 0 | 0 |  |  |  | Flexi Pan Connector | 0 |  |  | 0 | 0 |  |  |  | Flexi Pan Connector | 0 |  |  | 0 | 0
Flexi Pan Connector | 0 |  |  | 0 | 0 |  |  |  | Offset Pan Connector | 0 |  |  | 0 | 0 |  |  |  | Offset Pan Connector | 0 |  |  | 0 | 0
Offset Pan Connector | 0 |  |  | 0 | 0 |  |  |  | 40 mm P Trap/Wash mach adaptor | 0 |  |  | 0 | 0 |  |  |  | 40 mm P Trap/Wash mach adaptor | 0 |  |  | 0 | 0
40 mm P Trap/Wash mach adaptor | 0 |  |  | 0 | 0 |  |  |  | 3/4 to 22 mm Plastic tap connector | 0 |  |  | 0 | 0 |  |  |  | 3/4 to 22 mm Plastic tap connector | 0 |  |  | 0 | 0
3/4 to 22 mm Plastic tap connector | 0 |  |  | 0 | 0 |  |  |  | 3/4 to 22 mm soldered tap conn. | 0 |  |  | 0 | 0 |  |  |  | 3/4 to 22 mm soldered tap conn. | 0 |  |  | 0 | 0
3/4 to 22 mm soldered tap conn. | 0 |  |  | 0 | 0 |  |  |  | 3/4 to 15 mm Plastic tap connector | 0 |  |  | 0 | 0 |  |  |  | 3/4 to 15 mm Plastic tap connector | 0 |  |  | 0 | 0
3/4 to 15 mm Plastic tap connector | 0 |  |  | 0 | 0 |  |  |  | 3/4 to 15 mm soldered tap conn. | 0 |  |  | 0 | 0 |  |  |  | 3/4 to 15 mm soldered tap conn. | 0 |  |  | 0 | 0
3/4 to 15 mm soldered tap conn. | 0 |  |  | 0 | 0 |  |  |  | 15 mm Wash machine Valves | 0 |  |  | 0 | 0 |  |  |  | 15 mm Wash machine Valves | 0 |  |  | 0 | 0
15 mm Wash machine Valves | 0 |  |  | 0 | 0 |  |  |  | Programmer | 0 |  |  | 0 | 0 |  |  |  | Programmer | 0 |  |  | 0 | 0
Programmer | 0 |  |  | 0 | 0 |  |  |  | Room Stat | 0 |  |  | 0 | 0 |  |  |  | Room Stat | 0 |  |  | 0 | 0
Room Stat | 0 |  |  | 0 | 0 |  |  |  | Y Plan Control Kit | 0 |  |  | 0 | 0 |  |  |  | Y Plan Control Kit | 0 |  |  | 0 | 0
Y Plan Control Kit | 0 |  |  | 0 | 0 |  |  |  | S Plan Control Kit | 0 |  |  | 0 | 0 |  |  |  | S Plan Control Kit | 0 |  |  | 0 | 0
S Plan Control Kit | 0 |  |  | 0 | 0 |  |  |  | Radiator Pipe Entry Cover Plate | 0 |  |  | 0 | 0 |  |  |  | Radiator Pipe Entry Cover Plate | 0 |  |  | 0 | 0
Radiator Pipe Entry Cover Plate | 0 |  |  | 0 | 0 |  |  |  | 2 Gang Blank Plate | 0 |  |  | 0 | 0 |  |  |  | 2 Gang Blank Plate | 0 |  |  | 0 | 0
2 Gang Blank Plate | 0 |  |  | 0 | 0 |  |  |  | 3.5 mm Electrical [NAME] / 10 | 0 |  |  | 0 | 0 |  |  |  | 3.5 mm Electrical [NAME] / 10 | 0 |  |  | 0 | 0
3.5 mm Electrical [NAME] / 10 | 0 |  |  | 0 | 0 |  |  |  | TRV | 0 |  |  | 0 | 0 |  |  |  | TRV | 0 |  |  | 0 | 0
TRV | 0 |  |  | 0 | 0 |  |  |  | Lockshield inc drainoff | 0 |  |  | 0 | 0 |  |  |  | Lockshield inc drainoff | 0 |  |  | 0 | 0
Lockshield inc drainoff | 0 |  |  | 0 | 0 |  |  |  | Lockshield with wheelhead | 0 |  |  | 0 | 0 |  |  |  | Lockshield with wheelhead | 0 |  |  | 0 | 0
Lockshield with wheelhead | 0 |  |  | 0 | 0 |  |  |  | [NAME] | 0 |  |  | 0 | 0 |  |  |  | [NAME] | 0 |  |  | 0 | 0
[NAME] | 0 |  |  | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  | Total | 0 |  |  |  |  |  |  |  | Total | 0
 |  |  |  | Total | 0
 |  |  |  |  |  |  |  |  | UNVENTED CYLINDER
VENTED CYLINDER |  |  |  |  |  |  |  |  |  | Price | SL No | Notes | Total | Value | Labour | Total Labour
 | Price | SL No | Notes | Total | Value | Labour | Total Labour |  | [NAME] | 0 |  |  | 0 | 0
Vented Cylinder | 0 |  |  | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  | Total | 0
 |  |  |  | Total | 0