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
Rich (BB code):
[{=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.