suitcase_livin
New Member
- Joined
- Sep 2, 2014
- Messages
- 6
Hello, I'm trying to create a cascading dropdown list with a large set of numbers...
As an example the first data validation cell would have the options 10,20,30.
The user would select 10, and the second data validation cell would have the option 10.10, 10.20, 10.30, etc
Every google effort has led me to the Indirect function as the formula for the second data validation cell with the first cell as the parameter, but this only works for text.
Any suggestions?
As an example the first data validation cell would have the options 10,20,30.
The user would select 10, and the second data validation cell would have the option 10.10, 10.20, 10.30, etc
Every google effort has led me to the Indirect function as the formula for the second data validation cell with the first cell as the parameter, but this only works for text.
Any suggestions?