Avoid Repetition/Mismatch in TEXTJOIN of Cell Contents and a Named Range

[rfhandel]

Sorry for my ignorance in formulas. I use what I can beg, borrow, or steal, but I do not do a very good job of figuring them out on my own.

I am trying to extract metadata from a cell that is specifically relevant to various media used in an image. Each metadata term is separated by a delimiter (i.e. ";").

I have managed to use a TEXTJOIN formula to extract the data from a named range as demonstrated in the formula and screenshot below, with delimiters dividing the extracted text;

=TEXTJOIN(",",TRUE,IF(ISNUMBER(FIND(Table15[Media],D4)),MID(D4,FIND(Table15[Media],D4),LEN(Table15[Media])),""))

however, as indicated by the highlighted text below, the formula also extracts text that is not an exact match from the delimited text to the data entered in the named range (i.e. Acrylic AND Acrylic Gouache vs just Acrylic Gouache). How can I get the formula to read an exact match to the cells in the named range with the text from the target cell.

Secondly, but of less importance, how could I add a conjunction (i.e. "and") to the last extracted term in addition to or replacing the comma delimiter?

 

[rfhandel]

See post#7

My slow writing of responses (you can't see the original posts while replying)

 

[Fluff]

Glad we could help & thanks for the feedback.