Listing all values (referencing part of a cell value)

[surkdidat]

Sorry, another one...

I have created the formula

=INDEX(WIP!$A$2:$A$100, SMALL(IF($A$1=WIP!$K$2:$K$100, ROW(WIP!$K$2:$K$100)-ROW($A$2)+1), ROW(1:1)))

Which lists every single value on the WIP sheet (when dragged down) based on the value of A1.

What I am trying to do (and have tried to add "*"&$A$1&"*" in the middle of the formula, so that it can bring up more matches

So, in A1 I have the value "Horse"
However, I want to adjust the formula so it brings up matches of "Horse", "Seahorse", "Horses" etc (for example)

 

[surkdidat]

Ah, I have found a solution

=UNIQUE(FILTER('WIP'!A:A,IFERROR(FIND("Horse",'WIP'!K:K),0)>0))

 

[Fluff]

I have found a solution

In that case do you need to update your profile, as it shows 2016 which doesn't have Unique or Filter?