Drop Down lists?

[Guest]

I am trying to create a drop down list in a cell when the item is selected it
will populate values for that item in different cells. i.e In a drop down
menu you can select different types of shirts. When you select a particular
shirt from that drop down menu it will populate a price in a different cell
and a color in another cell. These values will be constant for each item.
Thanks in advance...

 

[Debra Dalgleish]

YOu can use data validation to create the dropdown list, and VLookup
formulas to show the related information in other cells.

There are instructions here for an order form, that uses those techniques:

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