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