Combine FIND and VLOOKUP?

[Quattro-Vienna]

I have a sheet with ingredients and brand-names.
On a second sheet, I would like to type in an ingredient and get all brand-names that contain this ingredient.

ingredients	brand-name
Diclofenac;Acetylicsalicylic acid	Aspirin
Diclofenac	Voltaren
Diclofenac;Coffein;Acetylicsalicylic acid	Thomapyrin
Diclofenac	Voltaren-Gel

Second Sheet

Ingredient	brand-1	brand-2	brand-3	brand-4
Acetylicsalicylic acid	Aspirin	Thomapyrin
Diclofenac	Aspirin	Voltaren	Thomapyrin	Voltaren-Gel

I hope somebody can help me or at least give some hints how to achieve this.

Best regards from Vienna!

Michael

[protonLeah]

(How to) Upload a Workbook directly to the Forum
(please do not post pictures or links to worksheets)

• Click Advanced next to Quick Post button at the bottom right of the editor box.
• Scroll down until you see "Manage Attachments",
• Click the "Choose" button at the upper left (upload from your computer).
• Select your file, click "open", click "upload"
• Once the upload is completed the file name will appear below the input boxes in this window.
• Close the Attachment Manager window.
• Click "Submit Reply"

Note: Please do not attach password protected workbooks/worksheets
Ensure to disable any Workbook Open/Autorun macros before attaching!