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

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.

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

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

"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

"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.

Thank you so much, your assistance was perfect!

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

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

Corminator wrote:
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





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