Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Validation List
Hi
Is it possible for the following:- Create a validation in Cell (A1) with list of Drinks, Food, Clothes Depending on what is selected the Validastion in cell (B1) will display Coke, Water if Drinks in chosen in A1, Cakes, Chocolate if Food is chosen and Hat , Glove if Clothes is chosen in cell A1 I hope I have given enough information Thanks in advance |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Validation List
Create a helper table in an unused part of your sheet, in my example G1:I3
G H I 1 drinks food clothes 2 water cakes hat 3 coke chocolate gloves and insert in the Source field of the Valiadation/List dialog the following formula: =IF(A1=$G$1,$G$2:$G$3,IF(A1=$H$1,$H$2:$H$3,$I$2:$I $3)) Regards, Stefi €˛Dilip Mistry€¯ ezt Ć*rta: Hi Is it possible for the following:- Create a validation in Cell (A1) with list of Drinks, Food, Clothes Depending on what is selected the Validastion in cell (B1) will display Coke, Water if Drinks in chosen in A1, Cakes, Chocolate if Food is chosen and Hat , Glove if Clothes is chosen in cell A1 I hope I have given enough information Thanks in advance |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Validation List
Hi
Add a page (p.e. ValLists) to your workbook. Create there a table Drinks, Food, Clotches (row 1 is header, data columnwise from row 2 without caps ) , like Drinks Food Clothes Coke Cakes Hat Water Chocolate Glove Milk Chips Candies Define named ranges (InsertNameDefine) Drinks=OFFSET(ValLists!$A$1,1,,COUNTA(ValLists!$A: $A)-1,1) Food=OFFSET(ValLists!$B$1,1,,COUNTA(ValLists!$B:$B )-1,1) Clothes=OFFSET(ValLists!$C$1,1,,COUNTA(ValLists!$C :$C)-1,1) On your original sheet (Sheet1?), for cell B1 define data validation list as =CHOOSE(MATCH(Sheet1!$A$1,{"Drinks";"Food";"Clothe s"},0),Drinks,Food,Clothes) -- Arvi Laanemets ( My real mail address: arvil<attarkon.ee ) "Dilip Mistry" wrote in message ... Hi Is it possible for the following:- Create a validation in Cell (A1) with list of Drinks, Food, Clothes Depending on what is selected the Validastion in cell (B1) will display Coke, Water if Drinks in chosen in A1, Cakes, Chocolate if Food is chosen and Hat , Glove if Clothes is chosen in cell A1 I hope I have given enough information Thanks in advance |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Validation List
Have a look at this:
http://www.contextures.com/xlDataVal02.html Hope this helps. Andy. "Dilip Mistry" wrote in message ... Hi Is it possible for the following:- Create a validation in Cell (A1) with list of Drinks, Food, Clothes Depending on what is selected the Validastion in cell (B1) will display Coke, Water if Drinks in chosen in A1, Cakes, Chocolate if Food is chosen and Hat , Glove if Clothes is chosen in cell A1 I hope I have given enough information Thanks in advance |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
drop-down list validation won't allow a different worksheet | Excel Worksheet Functions | |||
data validation list should have opt. to select based on criteria | Excel Worksheet Functions | |||
Expanding Data validation from List | Excel Discussion (Misc queries) | |||
validation list with drop down list of options?? | Excel Worksheet Functions | |||
list validation using list validation... | Excel Worksheet Functions |