Find a value from the first column - 2 values, 1 is a number range (EX: 19-20)

Thank you to all for your support as I'm relearning (and learning new) Excel. I've been able to complete everything on the attached sample file except for F2:F15. Really, I just need the formula for F2 (Subtest SC) and I will figure out the rest (good learning experience for me).

In short, F2:F15 are found by using the values from C2 (Age is the same for each Subtest) and E (Raw Score, which is entered manually).

The formula is I tried is in J2 (I didn't expect it to work though because of the number ranges like SC!B9). Just to test my formula I extended the SC worksheet so no number ranges existed (SC_Long). J3 - Same formula but pointing to the SC_Long sheet. If necessary (or easier) I can extend each sheet with number ranges in cells just like I did for SC.

Once again, any assistance is greatly appreciated.

Tom