in excel I want to set up a drop down & link that to another cell

[Guest]

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]

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

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

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

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

 

[Guest]

Thank you so much, this is exactly what I was looking for.

 

[Guest]

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.

Thank you so much, your assistance was perfect!

 

[Guest]

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]

In the cell below, you could use another VLOOKUP formula. Combine it
with and IF, to return an empty string if there is no associated option.
There's an example on the link I suggested earlier:

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