That was very helpfull!!

Iam still unsure how to apply a function that is specified in another cell.
these functions will be applied 20+ times, and they will be referencing
different cells each time (in a predictable pattern)

When I try this i just get the value of the cell holding the formula instead
of the formula itself being applied to the cell referencing it.


Thanks again!
Daiv

"Ragdyer" wrote:

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.