You can use Data Validation to create these drop down lists.

Check out these pages of Debra Dalgleish, where you can out everything about
them.

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

Scroll down to the D's, and see all the pages referring to Data Validation.
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Daiv" wrote in message
...
Hi,

I have seen spreadsheets that have a drop down control that is populated
by
a range of cells somewhere else in the spreadsheet. I would like to use
this
technique but cannot seem to get it working. can anyone help me with
this?

Also, I am going to want to reference the value of this list and assign
an
equation based on it's value.

Thanks for all your help!!!
Daiv.