MT,

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

HTH,

Conan




"mt" wrote in message
...
i would like a cell to be able to have 3 possible drop down lists depending
what the value of another cell is. Is this possible?

e.g. If cell c3 = 1 then i want cell c4 to have a drop down list
displaying
1,2,3,4
but if cell c3 = 2 then i want cell c4 to have a drop down list
displaying
5,6,7,8

i have tried to figure out an if statemet but can't. help!!!