Hi,

I'd need to scan a cell in (Sheet1) for the text in a specific column (A) of another sheet (Sheet2). Like a VLOOKUP, if the cell searched (Sheet1!C2) contains the text in one cell of the column (Sheet2!A), I'd like to add the text in another column (Sheet2!B) to the cell containing the formula (Sheet1!C3). There may be multiple values in the cell (Sheet1!C2) so I need to append the additional text. Finally, I need to do this with a formula rather than a macro (I think...) so that I can change the text in Sheet1!C or in Sheet2B and have the worksheet update.

I'm not sure if that makes any sense. Here's an example: Sample.xlsx

I noticed that any text that I don't need to search is inside of parenthesis, and a semicolon separates each set of values in both the cell to search, and also in the cell that I want to add the string to.

I tried doing this myself, but quickly realized that this was more involved than a VLOOKUP and a FIND. I'm out of my depth (which admittedly doesn't take much). I'd really appreciate some help on this one.