Spreadsheet: 872755d1719179388-returning-partial-match-when-comparing-two-columns-of-project-names-text-phrases-20240623_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. [NAME]'s attempt.
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
Mock Up of Expected Results (assuming no excluded words)
Project Name List 1 | Project Name List 2 | Expected Results reason | Expected Results from Project Name List 1
Air Liquide CurtHyl Hydrogen Production Electrolysis Project Phase I | Air Liquide SA Hyper1 green Hydrogen project | partial match from B2 in: A2:A12 because the word "Hydrogen" appears | Air Liquide CurtHyl Hydrogen Production Electrolysis Project Phase I | Air Liquide ELYgator Hydrogen Production Electrolysis PEM Project | Air Liquide Trailblazer Hydrogen Production Electrolysis Project Phase I | Cemex Concrete Chemicals Hydrogen Production Electrolysis Project Phase I | E.ON H2.Ruhr Hydrogen Production Electrolysis Project | E.ON SmartQuart Hydrogen Production Electrolysis Project | East Energy Finsterwalde Hydrogen Production Electrolysis Project | [NAME] | Enertag RefLau Hydrogen Production Stadtwerke Electrolysis Project Phase I | Equinor GreenHyScale Hydrogen Production Electrolysis Project Phase I | European Energy Kasso Hydrogen Production Electrolysis Project
Air Liquide ELYgator Hydrogen Production Electrolysis PEM Project | Air Liquide SA [NAME] Green Hydrogen Project | partial match from B3 in: A2:A12 because the word "Hydrogen" appears | Air Liquide CurtHyl Hydrogen Production Electrolysis Project Phase I | Air Liquide ELYgator Hydrogen Production Electrolysis PEM Project | Air Liquide Trailblazer Hydrogen Production Electrolysis Project Phase I | Cemex Concrete Chemicals Hydrogen Production Electrolysis Project Phase I | E.ON H2.Ruhr Hydrogen Production Electrolysis Project | E.ON SmartQuart Hydrogen Production Electrolysis Project | East Energy Finsterwalde Hydrogen Production Electrolysis Project | [NAME] | Enertag RefLau Hydrogen Production Stadtwerke Electrolysis Project Phase I | Equinor GreenHyScale Hydrogen Production Electrolysis Project Phase I | European Energy Kasso Hydrogen Production Electrolysis Project
Air Liquide Trailblazer Hydrogen Production Electrolysis Project Phase I | Siemens Energy AG, Air Liquide SA | partial match from B4 in,A2, A3, A4 due to words "Air" and "Liquide" | Air Liquide CurtHyl Hydrogen Production Electrolysis Project Phase I | Air Liquide ELYgator Hydrogen Production Electrolysis PEM Project | Air Liquide Trailblazer Hydrogen Production Electrolysis Project Phase I
Cemex Concrete Chemicals Hydrogen Production Electrolysis Project Phase I | Enertrag AG,[NAME] | partial match from B5 in A5 due to [NAME], and A10 due to Enertrag | Cemex Concrete Chemicals Hydrogen Production Electrolysis Project Phase I | Enertag RefLau Hydrogen Production Stadtwerke Electrolysis Project Phase I
E.ON H2.Ruhr Hydrogen Production Electrolysis Project | SAP AG,E.ON SE,[NAME],Iberdrola SA,ABB Ltd | partial match from [NAME] in A6 and A7 due to [NAME] (might be difficult in this case as there is no " " separator. | E.ON H2.Ruhr Hydrogen Production Electrolysis Project | E.ON SmartQuart Hydrogen Production Electrolysis Project
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 | partial match from [NAME] in A6 and A7 due to [NAME] (might be difficult in this case as there is no " " separator. | E.ON H2.Ruhr Hydrogen Production Electrolysis Project
East Energy Finsterwalde Hydrogen Production Electrolysis Project | East Energy GmbH,Stadtwerke Finsterwalde GmbH | patch match of Energy and East | East Energy Finsterwalde Hydrogen Production Electrolysis Project | European Energy Kasso Hydrogen Production Electrolysis Project
[NAME] | [NAME],VNG Gasspeicher GmbH | no partial matches
Enertag RefLau Hydrogen Production Stadtwerke Electrolysis Project Phase I | [NAME],Enertrag AG,[NAME] | partial match of Enertrag | Enertag RefLau Hydrogen Production Stadtwerke Electrolysis Project Phase I
Equinor GreenHyScale Hydrogen Production Electrolysis Project Phase I | Equinor ASA | partial match of equinor | Equinor GreenHyScale Hydrogen Production Electrolysis Project Phase I
European Energy Kasso Hydrogen Production Electrolysis Project | Green Hydrogen Example Project Proect Phase 1 | partial match of Hydrogen and Project in all project names. | Air Liquide CurtHyl Hydrogen Production Electrolysis Project Phase I | Air Liquide ELYgator Hydrogen Production Electrolysis PEM Project | Air Liquide Trailblazer Hydrogen Production Electrolysis Project Phase I | Cemex Concrete Chemicals Hydrogen Production Electrolysis Project Phase I | E.ON H2.Ruhr Hydrogen Production Electrolysis Project | E.ON SmartQuart Hydrogen Production Electrolysis Project | East Energy Finsterwalde Hydrogen Production Electrolysis Project | [NAME] | Enertag RefLau Hydrogen Production Stadtwerke Electrolysis Project Phase I | Equinor GreenHyScale Hydrogen Production Electrolysis Project Phase I | European Energy Kasso Hydrogen Production Electrolysis Project
Mock Up of Expected Results (with excluded words)
Project Name List 1 | Project Name List 2 | Expected Results reason | Expected Results from Project Name List 1
Air Liquide CurtHyl Hydrogen Production Electrolysis Project Phase I | Air Liquide SA Hyper1 green Hydrogen project | partial match on 'Air, ' and 'Liquide'. | Air Liquide CurtHyl Hydrogen Production Electrolysis Project Phase I | Air Liquide ELYgator Hydrogen Production Electrolysis PEM Project | Air Liquide Trailblazer Hydrogen Production Electrolysis Project Phase I
Air Liquide ELYgator Hydrogen Production Electrolysis PEM Project | Air Liquide SA [NAME] Green Hydrogen Project | partial match on 'Air, ' and 'Liquide'. | Air Liquide CurtHyl Hydrogen Production Electrolysis Project Phase I | Air Liquide ELYgator Hydrogen Production Electrolysis PEM 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 | partial match of 'Air' ,'Liquide' and 'Energy' | Air Liquide CurtHyl Hydrogen Production Electrolysis Project Phase I | Air Liquide ELYgator Hydrogen Production Electrolysis PEM Project | Air Liquide Trailblazer Hydrogen Production Electrolysis Project Phase I | European Energy Kasso Hydrogen Production Electrolysis Project
Cemex Concrete Chemicals Hydrogen Production Electrolysis Project Phase I | Enertrag AG,[NAME] | partial match from B5 in A5 due to [NAME], and A10 due to Enertrag | Cemex Concrete Chemicals Hydrogen Production Electrolysis Project Phase I | Enertag RefLau Hydrogen Production Stadtwerke Electrolysis Project Phase I
E.ON H2.Ruhr Hydrogen Production Electrolysis Project | SAP AG,E.ON SE,[NAME],Iberdrola SA,ABB Ltd | partial match from [NAME] in A6 and A7 due to [NAME] (might be difficult in this case as there is no " " separator. | E.ON H2.Ruhr Hydrogen Production Electrolysis Project | E.ON SmartQuart Hydrogen Production Electrolysis Project
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 | partial match from [NAME] in A6 and A7 due to [NAME] (might be difficult in this case as there is no " " separator. | E.ON H2.Ruhr Hydrogen Production Electrolysis Project
East Energy Finsterwalde Hydrogen Production Electrolysis Project | East Energy GmbH,Stadtwerke Finsterwalde GmbH | patch match of Energy and East | East Energy Finsterwalde Hydrogen Production Electrolysis Project | European Energy Kasso Hydrogen Production Electrolysis Project
[NAME] | [NAME],VNG Gasspeicher GmbH | no partial matches
Enertag RefLau Hydrogen Production Stadtwerke Electrolysis Project Phase I | [NAME],Enertrag AG,[NAME] | partial match of Enertrag | Enertag RefLau Hydrogen Production Stadtwerke Electrolysis Project Phase I
Equinor GreenHyScale Hydrogen Production Electrolysis Project Phase I | Equinor ASA | partial match of equinor | Equinor GreenHyScale Hydrogen Production Electrolysis Project Phase I
European Energy Kasso Hydrogen Production Electrolysis Project | Green Hydrogen Example Project Proect Phase 1 | partial match of Hydrogen and Project in all project names. | Air Liquide CurtHyl Hydrogen Production Electrolysis Project Phase I | Air Liquide ELYgator Hydrogen Production Electrolysis PEM Project | Air Liquide Trailblazer Hydrogen Production Electrolysis Project Phase I | Cemex Concrete Chemicals Hydrogen Production Electrolysis Project Phase I | E.ON H2.Ruhr Hydrogen Production Electrolysis Project | E.ON SmartQuart Hydrogen Production Electrolysis Project | East Energy Finsterwalde Hydrogen Production Electrolysis Project | [NAME] | Enertag RefLau Hydrogen Production Stadtwerke Electrolysis Project Phase I | Equinor GreenHyScale Hydrogen Production Electrolysis Project Phase I | European Energy Kasso Hydrogen Production Electrolysis Project