list with index/match with multiple results w/between criteria

[KDS14589]

I have a list of peoples scores. I wish a finale list of people that have a score between two numbers. I've tried several index/match formulas but nothing works. I think my problem is getting results between the criteria. My last attempt was

[{=IFERROR(INDEX($B$4:$B$14,SMALL(INDEX(MATCH($C$1:$C$2,$C$4:$C$14,0),),ROWS($A$1:A1))),"")}/CODE] but no luck. I posted an image because of download L2BB problems.

 

[Fluff]

How about

=IFERROR(INDEX($B$4:$B$14,AGGREGATE(15,6,(ROW($B$4:$B$14)-ROW($B$4)+1)/($C$4:$C$14>=$C$1)/($C$4:$C$14<=$C$2),ROWS(C$16:C16))),"")

 

[KDS14589]

How about

=IFERROR(INDEX($B$4:$B$14,AGGREGATE(15,6,(ROW($B$4:$B$14)-ROW($B$4)+1)/($C$4:$C$14>=$C$1)/($C$4:$C$14<=$C$2),ROWS(C$16:C16))),"")

It works THANKS

 

[Fluff]

You're welcome & thanks for the feedback.