I would like to find an exact match of a grape within a product name of different wines. The problem is that there are so many blends that if I use =if(isnumber(search or =if(isnumber(find the blends will not show since it will only fish for the first part of the grape name rather than the full cell name as I want it to. E.g. it will tag all the "Cabernet Malbec" and "Cabernet Merlot" as "Cabernet Sauvignon" anyway.
What formula should I use?
Please see the Excel Spreadsheet attached for example and desired outcomes.
Column A - Original name - this is what I already have given.
Column B - Grape - this is what I want as an end effect. I filled it now manually to show an example. That's where the formula would be.
Matching process - if "Original Name" includes the full "Look for" (Column E) within its cell, tag is as "Come back with" (Column F).
If it's not in the list, tag it as "Other".
Please note that the "Original name will always have the full grape varietal name, no shortcuts (like "chard") are used there.
They will also always start with a capital letter.