Not obvious to me what you mean.

On my current sheet I have to use a formula to search the description of the wine for each variety individually and then stich them all together. -

E.G for a wine with the description "Cantora's delicious cab shiraz merlot", I need 3 formulas to search the descriptoin and return the results - so I end up with 3 results in their own individual columns: "Cab Sauv", "Shiraz", and "Merlot". I then need a formula to stitch the three results together.


Is there a way to use just one formula to search the description for all the varieties at once?

there will be dozens and dozens of wine varieties, and each variety can have several abreviations - so doing a formula for every single variety will be a big problem.

I withdraw. Maybe someone else can help.