Sorry, another one...
I have created the formula
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)
I have created the formula
Excel 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)