Index & Match - return the next instance or x number of instances

I have a table A16:R305 (Sunday), I need to return the name in column A of the table ONLY if the value in Column R (Sell Out Miss) is "MISS."

I need it to return all the name values for "Miss." I know there are 5 in this table (=COUNTIF(Sunday[Sell Miss],"MISS"))

BUT my formula only returns the same (first) instance.

=INDEX(Sunday,MATCH("MISS",Sunday[Sell Miss],0),1)

How can I modify it to return all 5 instances?

Please see the yellow banner at the top of the page. Attach a sample workbook with mocked up answers and you'll get better/quicker responses.

How about

Formula:

Please Login or Register  to view this content.

Thanks, I figured it out :-)

=IF(M33>Sunday!$T$6,"",INDEX(Sunday!$A$16:$A$305,SMALL(IF(Sunday!$R$16:$R$305=$B$32,ROW(Sunday!$R$16:$R$305)-ROW(Sunday!$R$16)+1),COUNTIF($M$33:M33,"<="&Sunday!$T$6))))

T6 is hidden from view and contains the count of "miss" from column R.
M33 starts my numerical list - this is placed in M33: =IF(1>Sunday!$T$6,"",1) so it will only number the list the appropriate amount.

1 NAME
2 NAME
3 NAME