Drop down box Help needed

[Mark Palmer]

I have a worksheets with something like i have shown below
I want to enter the item manually in its own column.
I want to unit the and the broken unit cost manually in their own
columns
The forth column will be a drop down box - and the 5th column will
vary depending on which selection is made in the drop down

The purchase column will be a drop down box where we select weather
the item is purchased by the unit or broken unit. I then want excel to
display the approriate cost in the 5th column. The worksheet will then
have many items like this down the page. Hopefully I explained this
somewhat clearly....




Item Unit Cost Broken Unit Purchase Cost Used

Apples 1.00 1.50 unit 1.00


Thanks for any help you can give me.....

 

[Dave Peterson]

It sounds like you could use Data|Validation. But you want to have one
data|Validation dependent on a previous value.

Debra Dalgleish has some nice pictures explaining Data|Validation at:
http://www.contextures.com/xlDataVal01.html

And more notes for dependent lists at:
http://www.contextures.com/xlDataVal02.html