Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Drop down lists
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?! |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Drop down lists
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 "Jemma" wrote in message ... 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?! |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Drop down lists
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 --- "Jemma" wrote: 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?! |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Drop down lists
Thank you both very much, thats very helpful! |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Drop down lists
You are welcome.
-- Regards, Ashish Mathur Microsoft Excel MVP www.ashishmathur.com "Jemma" wrote in message ... Thank you both very much, thats very helpful! |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Drop down lists
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 |
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Drop down lists
Welcome. Pl go back and press the YES buttons (like the ones below) in the 2
responses which answered your query. -- Max Singapore http://savefile.com/projects/236895 Downloads:20,500 Files:365 Subscribers:65 xdemechanik --- "Jemma" wrote: Thank you both very much, thats very helpful! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Drop down lists that auto create and then filter the next drop down list | Excel Worksheet Functions | |||
how do I use one drop-list to modify another drop-lists options? | Excel Discussion (Misc queries) | |||
drop down lists | Excel Worksheet Functions | |||
Drop Down lists | Excel Worksheet Functions | |||
Multiple lists with repeated values for dependet drop down lists | Excel Worksheet Functions |