I'd like to have a drop-down list in one cell and based on
the selection in this cell, there needs to be another list
of drop downs in an adjacent cell. How do i do this?

See here http://www.contextures.com/xlDataVal02.html for chapter & verse.

Rgds,
Andy