In B6: =IF(N6="",TEXTJOIN(", ",TRUE,$C6:$M6),"Other")

Hi, thanks so much for the response! unfortunately that doens't solve my problem, and i think that's maybe my bad for not explaining clearly. I've re-worded my request:

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.

There will be dozens of different varieties and currently I'd have to create a formula for every single variety.