View Single Post
 
Old 01-28-2020, 12:07 AM
Cantora Cantora is offline Windows 10 Office 2019
Novice
 
Join Date: Jan 2020
Posts: 6
Cantora is on a distinguished road
Default

Quote:
Originally Posted by xor View Post
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.
Reply With Quote