Dependent Dropdown, referencing DRanges

[DarkJester89]

https://docs.google.com/spreadsheets/d/1JLq1yaPo5OwFXCldO4ruQKtBaVho1T2A59IQfgLUgOM/edit?usp=sharinghttp://i1275.photobucket.com/albums/y445/DarkJester89/Capture%20Photo_zpsc3qnmomn.png

I've been working on this worksheet for weeks and I'm on the very...last..formula.

There are 10 topics in all, and I could only do 7 nested-ifstatements in the data validation before it rang bells and stopped me fromfurther input. I tried to circumvent that but no use.
I also tried a name-managed list with the ranges being all10 what-ifs… which while they worked individually and fed back the drop downDRanges, …they all read as the false, (which feeds back a generic list oftopics.
The worksheets of interest are: Month1, Cell D4 and D5,andthe DRanges.
If D4 is Topic 1, Reference Topic 1 DRange to D5,
If D4 is Topic 2, Reference Topic 2 DRange to D5

I know I’m about waist deep in this, but this is the lastformula I need, and I’ve been at my PC for the better part of the past fewdays.

Thanks in advance.

 

[DarkJester89]

To make sure, the range or drop drop to go in D5, should count Topic 1 - Topic 10,