Dropdown inputs data in another cell.. ??

[FatMagic]

Hello,

I have a question.. I have a simple excel spreadsheet and i'm trying t
figure out how to get a dropdown menu to input data into another cel
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 t
input 0.50 for the price..

or if i choose Pear in the dropdown - two cells to the right it wil
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

 

[Bob Phillips]

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]

Still not 100% sure how to do it.. i see what you mean by making tha
small table off to the side to refer to.. but I don't know how to lin
it to the dropdown still..

=VLOOKUP(A1,H1:I4,2,FALSE)

what is the "A1" part refering to? is that supposed to point to th
dropdown?

Sorry for being a newbie at Excel tricks.. i only know the basics...

Thanks for the help

 

[ElsiePOA]

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

The first part of the formula (=IF(A1="","") will cause the cells i
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 fin
the number in column 2 that corresponds with the item you selected i
column A from the drop down menu

 

[FatMagic]

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