PaulM100 formula will work
BUT the order of the table is very important , otherwise you will get the wrong result
As you can see i have put just the single words at the end, otherwise , they would return the wrong result
also I have highlighted yellow, where the result is different to your sample - BUT i think the result is correct
I have also added where the words are interchanged ie
Malbec Syrah
Syrah Malbec
Both need to be in the lookup table
we can also use an IFERROR ()
to return other instead of #N/A
SO the 61 combinations need to be carefully ordered to get the correct results in the desired output
see what you thing of the attached
Bookmarks