#1   Report Post  
Old November 25th 05, 08:03 AM posted to microsoft.public.excel.worksheet.functions
Dilip Mistry
 
Posts: n/a
Default 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   Report Post  
Old November 25th 05, 09:21 AM posted to microsoft.public.excel.worksheet.functions
Stefi
 
Posts: n/a
Default 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   Report Post  
Old November 25th 05, 09:28 AM posted to microsoft.public.excel.worksheet.functions
Arvi Laanemets
 
Posts: n/a
Default 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   Report Post  
Old November 25th 05, 11:02 AM posted to microsoft.public.excel.worksheet.functions
 
Posts: n/a
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
drop-down list validation won't allow a different worksheet justmetn Excel Worksheet Functions 4 September 15th 05 05:33 PM
data validation list should have opt. to select based on criteria be Excel Worksheet Functions 1 September 15th 05 01:05 PM
Expanding Data validation from List mark hansen Excel Discussion (Misc queries) 2 September 4th 05 01:39 AM
validation list with drop down list of options?? luke013 Excel Worksheet Functions 1 August 31st 05 01:16 PM
list validation using list validation... Patrick G Excel Worksheet Functions 1 December 21st 04 12:37 AM


All times are GMT +1. The time now is 01:35 AM.

Powered by vBulletin® Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
Copyright 2004-2019 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017