I have a huge file that is similar to the one below. I'd like to be able to compare the group of words in column A with the group of words in column B and get "No Match", "Exact Match" or "Partial Match" in column C. I'm basic user with formulas and can use VBA to save and run macros.
Small notes, the columns do have duplicates and the comparison needs to be done only on cell by cell (E.g A1 with B1). Even a simpler form of this will help. Thank you.
A - classement fifa, classico barca real, clavier arabe, clermont ferrand
B - green grass soccer, hotel europa, clavier arabe, ferrand
C - No Match, No Match, Exact Match, Partial Match
- I've tried variations of VLOOKUP and SEARCH but without results.
- I've tried Text to Columns and then VLOOKUP the 2 sets of texts but it will still show partial data which I can't use.
- The closest answer I could get was How can I compare two columns in Excel to highlight words that don't match? but when I run the macro for all my columns, it ignores the duplicates and doesn't compare A1 with B1, it seems to check A:A with B:B and I still need to manually check for No Match, Exact Match and Partial Match which is extremely time consuming.
I would like to match whole words with partial words when searching for partial matches -
Cup vs Cupboard = Partial
Cupcake vx Cupboard = No Match