How to compare different solutions brands and extract specific ones?

Hi to the community,

I'm working on the file "Extraction".

I would like to compare the sheet "Feuil 1" and "Feuil 2". After the comparison, I would like to extract the solutions from the sheet "Feuil 2" that are not established in the sheet "Feuil 1".

In the sheet "Feuil1", the solution's name are located in column A.
In the sheet "Feuil 2", the solution's name are located at the beginning of each sentence, fo example, in the cell G2 "Coupa vs Basware: AP Automation head-to-head technology evaluation and comparison

Thank you a lot for your help and investment for others

Ok AliGW and Glenn Kennedy. I share you the updated workbook with expected results in the file "Extraction v0.2".

A guess,

Please Login or Register  to view this content.

windknife, those ones seems to be missing in your list.

Coupa vs. SAP Ariba
Dhatim Conciliator
Ivalua vs. SAP Ariba
Jaggaer vs SAP Ariba
Oracle Procurement Contracts Cloud
Oracle vs. Coupa
Statess (State of Flux)
Tipalti's Payment Capability

DJunqueira, windknife.

When I use your formulas, they don't work because my solution data doesn't have the right character formalism.

I need to work on the harmonization of the data. For example, SIEVO in the sheet "Feuil 1" need to be Sievo.

I work this on my side and I will apply your formulas after this "cleaning".

Capital letter doesn't seems to be the problem, but misspelling does.

Apexanalytics X APEX Analytix

Another try,

Please Login or Register  to view this content.

With PQ.
This time I made sure the capital letters were the same.

Formula:

Please Login or Register  to view this content.

Thank you DJunqueira. It's working. Fun naming for the tab "Feuil PQ" In French, that means toilet paper.

This mess with language is very funny.