You could name the second range something slightly different, e.g. if
the first range is named "Fruit", name the second one "FruitB"

Then, in the data validation source for the second dropdown, use the
formula:
=INDIRECT(B3&"B")

Patty via OfficeKB.com wrote:
Thank you!

Is the only possible way to do this is with named ranges? Because in the
contextures.com example, supposed I am using the produce list for a third
drop down menu. How can I have the same name for 2 different named ranges?


Debra Dalgleish wrote:

There are instructions here for creating dependent data validation lists:

http://www.contextures.com/xlDataVal02.html


I have a drop down menu of two options (yes or no) in cell A1. Cell B1 has
another drop down menu of 50 options. Is it possible that when "yes" is
selected in A1 only certain options appear in the B1's drop down menu, and
that when "no" is selected in A1, certain other options appear?





--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html