select dropdown list dependant on value of a given cell

[Guest]

Can anyone tell me how i can select a dropdown list dependant on value of a
given cell or in otherwords display different dropdown lists dependent on the
value previously entered or displayed in another cell.

 

[Dave Peterson]

So you want a dependent list using data|validation?

See Debra's site again!
http://contextures.com/xlDataVal02.html

 

[Pete_UK]

Debra Dalgleish show how here:

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

Hope this helps.

Pete