Dropdown inputs data in another cell.. ??

Hello,

I have a question.. I have a simple excel spreadsheet and i'm trying to
figure out how to get a dropdown menu to input data into another cell
after I choose the data from the dropdown..

for example:

I have a list of 4 things in the drop down menu:
Apple
Pear
Orange
Banana

When I choose say.. the Apple - two cells to the right I want it to
input 0.50 for the price..

or if i choose Pear in the dropdown - two cells to the right it will
input 0.75 for the price..

I'm sure there is a way to do this.. just unsure how to do it!

Thanks!

-Chris B.


---
Message posted from http://www.ExcelForum.com/

Either have a table in say H1:I4 with Apple, 0.50, Pear, 0.75, etc., and in
the target cell

=VLOOKUP(A1,H1:J4,2,False)


--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"FatMagic " wrote in message
...
Hello,

I have a question.. I have a simple excel spreadsheet and i'm trying to
figure out how to get a dropdown menu to input data into another cell
after I choose the data from the dropdown..

for example:

I have a list of 4 things in the drop down menu:
Apple
Pear
Orange
Banana

When I choose say.. the Apple - two cells to the right I want it to
input 0.50 for the price..

or if i choose Pear in the dropdown - two cells to the right it will
input 0.75 for the price..

I'm sure there is a way to do this.. just unsure how to do it!

Thanks!

-Chris B.


---
Message posted from http://www.ExcelForum.com/

Put the list for your dropdown menu in alphbetic order and place the
prices in the next column. Then, select the list and the prices as a
range and name the range "TBL". Now, assuming you will be entering the
items from the drop down menu in cells A1:A20, in cells C1:C20 enter th
following formula: =IF(A1="","",VLOOKUP(A1,TBL,2,false)).

The first part of the formula (=IF(A1="","") will cause the cells in
column C to remain empty until the cell in Column A has a entry in it.
The rest of the formula will look a the range you named "TBL" and find
the number in column 2 that corresponds with the item you selected in
column A from the drop down menu.


---
Message posted from http://www.ExcelForum.com/

I got it! Great thank you very much.. works exactly how I wanted it to..
took a bit of tinkering and thanks to both of you guys I got it!

Thanks again!


---
Message posted from http://www.ExcelForum.com/