Hi,

I'm trying to provide a report that splits wine up in to it's varieties based on the bottle description.
I want to:
1. Read the description (in column A)
2. looks through the table on sheet "Varietie", column A for matching varieties
3. Provide the combination of Varieties from sheet "Varieties", column B.

The issue is that the wine might have multiple varieties in it - and so I want to search the description for key words and then return those key words in to a single cell.

i've managed to do this by separating varieties in to different columns (C:M) and then using a simple vba script to combine them in to column B, but i'm wondering if there's a way to do this simpler via maybe just one or two formulas. In the attached example I've highlighted two lines that contain multiple varieties and combine these together.

Any help is appreciated.

This data attached is only for red wine for 1 month - but i'll have to do this for white wine and across a year - so the data will grow a lot and i'll end up needing dozens of different separate varieties

Cheers!
Dave

Attached Files

Wine List.xlsx (34.0 KB, 13 views)