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.

Debra Dalgleish has a web page on this subject ... called "dependant lists".

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

--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Vanna" wrote in message
...
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.