Looking for an arry function to return cells containing a text string

[Quaker2001]

I work in a scheduling department we build all our schedules into an Excel grid for our employees. In order to more easily search for all the people working a given shift on a particular day, I created the following array function..
{=SMALL(IF($C$1:$C$200=E$2,ROW($C$1:$C$200)),ROW(1:1))}

From there, I use an Index function to pull up the names corresponding to all the rows, which has been working well. Unfortunately, the way people's shifts have been entered are no longer uniform. So rather than looking for individual values, I was hoping to use a search for a text string in a similar fashion, to return matching values and then using an index to match up names. I tried this, but Excel isn't giving me much help to step through the calculations..
=small(if(isnumber(search(k$30,$c$1:$c$200))),row($c$1:$c$200),row(1:1))

Any suggesting on how to make this work? Thanks

[FDibbins]

Hi, welcome to the forum

Hard to work blind on something like this, I suggest that you upload a small (clean) sample workbook (not a pic) of what you are working with, and what your expected outcome would look like.

To attach a file to your post,
click advanced (next to quick post),
scroll down until you see "manage file",
click that and select "add files" (top right corner).
click "select files" find your file, click "open" click "upload" click 'done" bottom right. click "submit reply"

Once the upload is completed the file name will appear below the input boxes in this window.
You can then close the window to return to the new post screen.

[bebo021999]

Not sure, but try:

=small(if(isnumber(search(k$30,$c$1:$c$200)),row($c$1:$c$200),""),row(1:1))

[Quaker2001]

That did the trick. Looks like I was missing the value_if_false argument from the IF function, so the "" fixed it. Thanks!!