G
Guest
I remember seeing this solution some where but cannot recall.
I would like to create a data validation list based on a value enter into a
cell.
For example. if I enter "fruits" in cell A1, then cell B1 would return a
list of fruits drop down list and if I change cell A1 to "Vegetables", then
the drop down list in B1 should return a list of Vegetables.
I remember this can be done using a combination of Data validation and the
indirect function. Any help would be much appreciated.
I would like to create a data validation list based on a value enter into a
cell.
For example. if I enter "fruits" in cell A1, then cell B1 would return a
list of fruits drop down list and if I change cell A1 to "Vegetables", then
the drop down list in B1 should return a list of Vegetables.
I remember this can be done using a combination of Data validation and the
indirect function. Any help would be much appreciated.