Drop down lists

J

Jemma

hi i am creating an excel table which contains a data validation drop down
list. I would like to know if there is any way of linking an option selected
from the drop down list to another cell. E.g. my list contains 'Kingston,
Sutton, Wimbledon..' and i would like '£12.00' to appear in another cell when
Kingston is selected, '£8.00' when Sutton is selected and '£3.00' when
Wimbledon is selected. Is this possible? if so how?!
 
A

Ashish Mathur

Hi,

You can write the following IF() statement. I am assuming that the Data >
Validation > Drop down list is in cell A1.

=if(A1="Kingston",12,if(A1="Sutton",8,2))

Once you have written this formula, format the cell (Ctrl + 1) as currency.

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com
 
M

Max

One way is to use a vlookup

Assume the reference listing (Location - Price)
is in Sheet2's cols A and B
eg: Kingston, 12

In Sheet1,
Assume DVs in A2 down
In B2: =IF(A2="","",VLOOKUP(A2,Sheet2!A:B,2,0))
Format B2 as currency to taste, copy down
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:20,500 Files:365 Subscribers:65
xdemechanik
 
J

Jemma

i have another question actually. Is it possible to select more than one
choice from a drop down menu? if so how? and please dumb it down for me! haha
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to make repeating drop-down lists? 2
Drop down list control value in vba 2
How can I give customized drop down in Ms Forms online or refer dropdown from excel list 0
Link a text box based on drop down box with four options MS Word 365 0
Drop down lists in seperate columns 5
MS Project Center-Autolink column fields 0
Excel 2013: New row added automatically but first 2 columns Drop down lists not available... 0
Limit drop down items based on another cell 3

Top