Now that this working perfectly, is there a way to automatically fill in the
cell below the drop down when a specific item is selected? What I mean is
that, on the drop down menu, hamburger is selected, the cell below
automatically gets filled in with french fries? Not every item in the drop
down will have an option associated with it.

"Debra Dalgleish" wrote:

To return the related information for the selected item, you can use a
VLookup formula. There are instructions and examples he

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

There's a sample file that uses Data Validation and VLookup formulas he

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


Corminator wrote:
I created a drop down list. What I would like to do is have another cell
automatically filled in with a value when an item is selected from the drop
down. For example, a drop down menu ( hamburger, hot dog, etc) and when one
is chosen, the price for that item would get filled in automatically in
another cell.


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html