|
|
This might help
http://www.contextures.com/xlDataVal02.html
Regards,
peo Sjoblom
"Ryan" wrote:
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?
|