Spreadsheet: 749979d1633129465-find-a-row-of-info-by-using-keywords-display-rows-of-data-based-on-indexing-keywords-rgrohman-
Sheet: Sheet1

Keyword | Plumbing
Type | [NAME] | Contact 1 | Contact 1 # | Contact 2 | Contact 2 # | Office# | [NAME] 1 | [NAME] 2 | Counties Served | MSA
Keywords | Type | [NAME] | Contact 1 | Contact 1 # | Contact 2 | Contact 2 # | Office# | [NAME] 1 | [NAME] 2 | Counties Served | MSA
 | Landscaping | [NAME] | [NAME] | [PHONE] |  |  |  | [EMAIL] |  | Lebanon/Dauphin | No
 | Fencing | Tyson Fence Co. | [NAME] | [PHONE] |  |  | [PHONE] | [EMAIL] |  | 45 Minutes from Harrisburg | No
 | Life Safety | Berkshire Systems Group | [NAME] | [PHONE] | [NAME] | [PHONE] | [PHONE] | [EMAIL] | [EMAIL] | Statewide | Yes
 | Life Safety/Security | Alwine Security | [NAME] | [PHONE] | [NAME] | [PHONE] | [PHONE] | [EMAIL] | [EMAIL] | Lancaster, Chester, Berks, Lebanon, York, Adams, Cumberland, [NAME], [NAME] and [NAME] | Yes
 | Roofing/Siding | Allied Roofing | [NAME] | [PHONE] | [NAME] | [PHONE] | [PHONE] | [EMAIL] | [EMAIL] |  | Yes
 | Painting | [NAME] | [NAME] | [PHONE] |  |  |  | [EMAIL] |  |  | Yes
 | Paving/Seal Coating | A+ Seal Coating |  |  |  |  |  |  |  |  | Yes
 | Painting | Capital Painting |  |  |  |  |  |  |  |  | Yes
 | Electrical | [NAME] | [NAME] | [PHONE] | [NAME] | [PHONE] | [PHONE] | [EMAIL] | [EMAIL] |  | Yes
 | Painting | Certipro |  |  |  |  |  |  |  |  | Yes
 | Landscaping | [NAME] |  |  |  |  |  |  |  |  | Yes
 | Mechanical/HVAC | D&T Mechanical Contractor |  |  |  |  |  |  |  |  | Yes
 | Life Safety | Diamond Automatic Sprinklers |  |  |  |  |  |  |  |  | Yes
 | Elevator Inspections | Dominion Elevator |  |  |  |  |  |  |  |  | Yes
 | HVAC/Mechanical/Controls/Electrical | Dynamech |  |  |  |  |  |  |  |  | Yes
 | HVAC/Mechanical/Plumbing | Enginuity |  |  |  |  |  |  |  |  | Yes
 | Cleaning | Facility Concierge Services |  |  |  |  |  |  |  |  | Yes
 | Signage | Fast Signs (Harrisburg) |  |  |  |  |  |  |  |  | Yes
 | Power Washing | Full Blast Pressure Washing |  |  |  |  |  |  |  |  | Yes
Doors, Windows, [NAME], Store Fronts, Door Hardware | Doors/Windows/Glass | Hershocks |  |  |  |  |  |  |  |  | Yes
 | Cleaning | [NAME] |  |  |  |  |  |  |  |  | Yes
[NAME], Fire Suppression System, Fire Alarm System, Security Alarm System, Card Access System, Emergency / Exit Lighting, Gas Detection System, Sprinkler System, [NAME] | Life Safety | Kint |  |  |  |  |  |  |  |  | Yes
Access Control, CCTV, Security Alarms, Fire Alarms | Life Safety | LowV |  |  |  |  |  |  |  |  | Yes
Building Automation Systems (BAS/ATC), Card Access,  Security Systems,  Energy Star Services, Lighting Control Systems | Controls | NRG Controls |  |  |  |  |  |  |  |  | Yes
Building Automation Systems, Design/Build Services, [NAME] to [NAME] upgrades, Building Automation System integrations, Service Support Agreements | Controls | OAESYS |  |  |  |  |  |  |  |  | Yes
Pest Control | Pest Control | [NAME] |  |  |  |  |  |  |  |  | Yes
Garage Doors, Door Operators, Loading Dock Equipment | Doors | Overhead door |  |  |  |  |  |  |  |  | Yes
Generator Service | Generator Service | Penn Power Systems |  |  |  |  |  |  |  |  | Yes
Facility Services Division, General Construction, Design/Build, Construction Management | Construction | Pyramid |  |  |  |  |  |  |  |  | Yes
 | Cleaning | ServiceMaster |  |  |  |  |  |  |  |  | Yes
 | Cleaning | Sheffield |  |  |  |  |  |  |  |  | Yes
Plumbing, Heating, HVAC, Sprinkler Systems, Mechanical | Mechanical/HVAC | S&L Mechanical | [NAME] | [PHONE] | [NAME] | [PHONE] 103 | [PHONE] | [EMAIL] | [EMAIL] |  | Yes
 | Pest Control | [NAME] |  |  |  |  |  |  |  |  | Yes
 |  | TruGreen |  |  |  |  |  |  |  |  | Yes
 |  | [NAME] |  |  |  |  |  |  |  |  | Yes
 | Fire Sprinkler Systems | [NAME] |  |  |  |  |  |  |  |  | Yes
Doors, Windows, [NAME], Store Fronts, Door Hardware | Doors/Windows/Glass | Weavers [NAME] |  |  |  |  |  |  |  |  | Yes
 |  | Water Treatment by Design |  |  |  |  |  |  |  |  | Yes
Heating, Cooling, Refrigeration, Food Service Equipment, Water Heaters, Air and water Quality, Green Solutions |  | Thermotech