In cell A1 I have a drop down list with 15 options.

I have 15 seperate named lists which correspond to the options in the first
list.

In cell B1, I want another dropdown list which corresponds to the option
chosen in A1. Using nested if statements in the B1 "list source" window, I
can only get up to 7 corresponding lists.

I tried using a vlookup, but the value is not recognized as a Name,
therefore it is invalid as a list source.

Is there any way around this?