I am trying to run the following code to return all the matches of column A from column C in a set of rows. In this situation, cell A1, is contained in a few iterations of column C, however, these are not exact matches. i.e I would want a match for this cell https://i.postimg.cc/FzHBMnVc/KENKD00319-03-KDLP0808-WHITE-3235.jpg as KDLP0808 is contained in the URL.
I am using the code below to do this
=IFERROR(INDEX(C:C,SMALL(IF("*"&A1&"*"=C:C,ROW(C:C)- MIN(ROW(C:C))+1,""),COLUMN()-4)), "")