Data Validation-Dependant Lists-Multiple

[lunker55]

Is there a way to get 2 different INDIRECT data validation lists from one
main validation?

ie. cell A1 has a data validation list of silver,gold,red,blue.

If cell A1 is "silver", I want an INDIRECT data validation list with
1,2,3,4,5 in cell B1

If cell A1 is "silver", I want an INDIRECT data validation with
Mats,Owen,Joe,Alex,Ed in C1.

Thanks,

Joe

 

[JE McGimpsey]

See

http://www.contextures.on.ca/xlDataVal02.html

 

[Frank Kabel]

Hi Joe
for dependent listboxes have a look at
http://www.contextures.com/xlDataVal02.html

Frank