Finding wildcards in indexing and aggregate functions.

[ecalid]

Hello again guys,

I hope you are all well.

I'm struggling with this piece of code, I can't seem to find wildcards within lists, only exact values.

I need to return all the values located in C with the specific value, in this case "Extrusion", located in D. However, the cell might contain such lines as "Extrusion, Lamination, Mixing"

When I add the wildcard *, it wont work. Is there another way of doing this?

=IFERROR(INDEX($C$2:$C$500,AGGREGATE(15,6,(1/($B$2:$B$500="Extrusion"))*ROW($C$2:$C$500)-ROW($A$2)+1,ROW(A2))),"")

Many thanks,

[p45cal]

=IFERROR(INDEX($C$2:$C$500,AGGREGATE(15,6,(1/ISNUMBER(SEARCH("Extrusion",$B$2:$B$500)))*ROW($C$2:$C$500)-ROW($A$2)+1,ROW(A2)-1)),"")

?

[ecalid]

Wow! Thanks for this, it worked a treat!

Thank you so much!