Named Ranges and INDEX/MATCH

I am trying to use Index and Match in conjunction with named ranges. The trick is that I need to use Lookup in order to determine which named range to use. For example, here is the formula I need:

=INDEX(FR_2004,MATCH(H10,FR_2004_Spec,0),L2+1)

As you can see, I am using 2 named ranges: FR_2004 and FR_2004_Spec. However, in order to determine these named ranges, I am using the following formula, which returns "FR_2004":

="FR_"&RIGHT(TEXT(LOOKUP(C3,B16:B27),"m/d/yyyy"),4)

I tried plugging the above into the Index/Match formula, but obviously, it doesn't work. Is there a trick to make this work? I have attached a sample of the file with the table I am using.

TIA for any help.

Jason