Dependent drop down list from Index Match

Thanks John, I don't think I explained myself very well though, so I have attached an example of what I'm talking about.

In the attached, I am looking to have the red cell (J6) become a drop down list, depending on the selection made in the yellow cell (J3). The extra step is that the named range cannot be the same name as what is in J3, so I used a naming table (columns B and C) and an index / match formula to transform the name (seen in J4).

The Offset formula used to name the ranges is definitely working, because I have tested that in cell J5, but for some reason the indirect reference to J3 does not work when I try and make the dropdown for J6.