Spreadsheet: 872676d1719041914-returning-partial-match-when-comparing-two-columns-of-project-names-text-phrases-20240622_excel-forum-ask
Sheet: Excel Forum (2)

Project Name List 1 | Project Name List 2
Air Liquide CurtHyl Hydrogen Production Electrolysis Project Phase I | Air Liquide SA Hyper1 green Hydrogen project |  | Air Liquide ELYgator Hydrogen Production Electrolysis PEM Project | E.ON SmartQuart Hydrogen Production Electrolysis Project | East Energy Finsterwalde Hydrogen Production Electrolysis Project
Air Liquide ELYgator Hydrogen Production Electrolysis PEM Project | Air Liquide SA [NAME] Green Hydrogen Project |  | Air Liquide ELYgator Hydrogen Production Electrolysis PEM Project | E.ON H2.Ruhr Hydrogen Production Electrolysis Project | East Energy Finsterwalde Hydrogen Production Electrolysis Project | [NAME]
Air Liquide Trailblazer Hydrogen Production Electrolysis Project Phase I | Siemens Energy AG, Air Liquide SA Hydrogen
Cemex Concrete Chemicals Hydrogen Production Electrolysis Project Phase I | Enertrag AG, [NAME]
E.ON H2.Ruhr Hydrogen Production Electrolysis Project | SAP AG,E.ON SE,[NAME],Iberdrola SA,ABB Ltd
E.ON SmartQuart Hydrogen Production Electrolysis Project | [NAME],OFB Projektentwicklung GmbH,[NAME],Viessmann Group,Hydrogenious LOHC Technologies GmbH,Cisco Systems Holding GmbH,RWE Power AG,Siemens AG
East Energy Finsterwalde Hydrogen Production Electrolysis Project | East Energy GmbH,Stadtwerke Finsterwalde GmbH
[NAME] | [NAME],VNG Gasspeicher GmbH
Enertag RefLau Hydrogen Production Stadtwerke Electrolysis Project Phase I | [NAME],Enertrag AG,[NAME]
Equinor GreenHyScale Hydrogen Production Electrolysis Project Phase I | Equinor ASA
European Energy Kasso Hydrogen Production Electrolysis Project | Green Hydrogen Example Project Proect Phase 1 |  | Cemex Concrete Chemicals Hydrogen Production Electrolysis Project Phase I
Above is AliGW solution 1, 22/6/24 | Words to ideally exclude from partial match test. Ideally not case sensitive.
Somehow excludes certain words but not sure how. | Hydrogen
 | green
 | hub
 | project
 | electrolysis
Formula two.
Project Name List 1 | Project Name List 2
Air Liquide CurtHyl Hydrogen Production Electrolysis Project Phase I | Air Liquide SA Hyper1 green Hydrogen project |  | E.ON SmartQuart Hydrogen Production Electrolysis Project
Air Liquide ELYgator Hydrogen Production Electrolysis PEM Project | Air Liquide SA [NAME] Green Hydrogen Project |  | Air Liquide Trailblazer Hydrogen Production Electrolysis Project Phase I
Air Liquide Trailblazer Hydrogen Production Electrolysis Project Phase I | Siemens Energy AG, Air Liquide SA
Cemex Concrete Chemicals Hydrogen Production Electrolysis Project Phase I | Enertrag AG,[NAME]
E.ON H2.Ruhr Hydrogen Production Electrolysis Project | SAP AG,E.ON SE,[NAME],Iberdrola SA,ABB Ltd
E.ON SmartQuart Hydrogen Production Electrolysis Project | [NAME],OFB Projektentwicklung GmbH,[NAME],Viessmann Group,Hydrogenious LOHC Technologies GmbH,Cisco Systems Holding GmbH,RWE Power AG,Siemens AG
East Energy Finsterwalde Hydrogen Production Electrolysis Project | East Energy GmbH,Stadtwerke Finsterwalde GmbH
[NAME] | [NAME],VNG Gasspeicher GmbH
Enertag RefLau Hydrogen Production Stadtwerke Electrolysis Project Phase I | [NAME],Enertrag AG,[NAME]
Equinor GreenHyScale Hydrogen Production Electrolysis Project Phase I | Equinor ASA
European Energy Kasso Hydrogen Production Electrolysis Project | Green Hydrogen Example Project Proect Phase 1