Lookup if a number is within a range and return cell value, with multiple results

Hello,
I have been working on a formula for a couple weeks and cannot figure it out!

I need to determine if a number is within a range, then give a value based on the result. However, the ranges are not mutually exclusive, so there could be multiple results.

For example:

Col A...............Col B................Col C
Low Degree......High Degree.......Color
88..................115..................Red
32..................95....................Blue
36..................97....................Orange
36..................86....................Yellow

So if my look-up value is 52, the results would be Blue, Orange and Yellow.

The formula I've used looks like this:

=IFERROR(INDEX($A$36:$C$60,SMALL(IF(AND($A$36:$A$60<=$D$9,$B$36:$B$60>=$D$9),ROW($A$36:$A$60)-35),ROW(A1)),3),"") - Entered using Control+Shift+Enter

However, this only returns the first item in the list (ie "Red"), no matter what the look-up value is. (In the above formula, $D$9 = 52 in my example.)

Any ideas? I'm desperate!

Thanks!

It works!!!! Thank you SOOOOO much! You are my hero!