Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Data Validation (2 lists)
Hello, I have 2 different "Lists" with a "Name" defined to each, and I would
like to use them both on a Data Validation but it seems it is not as simple as =AND(NAME1,NAME2). It gives me a error in that way, any ideas to be able to use both? ,thanks |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Data Validation (2 lists)
I don't believe you can do what you require so you will need to combine into
one list. And I'm not sure why you would want to use two lists. "Ed" wrote: Hello, I have 2 different "Lists" with a "Name" defined to each, and I would like to use them both on a Data Validation but it seems it is not as simple as =AND(NAME1,NAME2). It gives me a error in that way, any ideas to be able to use both? ,thanks |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Data Validation (2 lists)
Assuming there is some other cell whose value decides which List you wish to
use, then you could do a Change-event macro on that cell to set up the DataValidation on the other cell to use the appropriate list. hth Vaya con Dios, Chuck, CABGx3 "Ed" wrote: Hello, I have 2 different "Lists" with a "Name" defined to each, and I would like to use them both on a Data Validation but it seems it is not as simple as =AND(NAME1,NAME2). It gives me a error in that way, any ideas to be able to use both? ,thanks |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Data Validation (2 lists)
I don't think you can do that, but would need to create a third list with
the matched items. -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "Ed" wrote in message ... Hello, I have 2 different "Lists" with a "Name" defined to each, and I would like to use them both on a Data Validation but it seems it is not as simple as =AND(NAME1,NAME2). It gives me a error in that way, any ideas to be able to use both? ,thanks |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Data Validation (2 lists)
http://cjoint.com/?gDvlrMsErZ
=IF(Row()<=CountA(champ1),INDEX(champ1,LIGNE()),IN DEX(champ2;Row()-Counta(champ1))) Cordialy JB Ed a écrit : Hello, I have 2 different "Lists" with a "Name" defined to each, and I would like to use them both on a Data Validation but it seems it is not as simple as =AND(NAME1,NAME2). It gives me a error in that way, any ideas to be able to use both? ,thanks |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Data Validation (2 lists)
You could use a custom formula, but you won't see a dropdown.
=OR(ISNUMBER(MATCH(A1,list1,0)),ISNUMBER(MATCH(A1, list2,0))) Ed wrote: Hello, I have 2 different "Lists" with a "Name" defined to each, and I would like to use them both on a Data Validation but it seems it is not as simple as =AND(NAME1,NAME2). It gives me a error in that way, any ideas to be able to use both? ,thanks -- Dave Peterson |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
Data Validation (2 lists)
Another option is to use formulas to create a single list from multiple
lists, as shown in the sample file he http://www.contextures.com/excelfiles.html#DV0014 Under Data Validation, look for 'Combine Multiple Lists into One' Ed wrote: Hello, I have 2 different "Lists" with a "Name" defined to each, and I would like to use them both on a Data Validation but it seems it is not as simple as =AND(NAME1,NAME2). It gives me a error in that way, any ideas to be able to use both? ,thanks -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Data Validation and named lists | Excel Worksheet Functions | |||
Inputting data to one worksheet for it effect another | Excel Discussion (Misc queries) | |||
Font size in data validation drop down lists | Excel Discussion (Misc queries) | |||
6 Data Validation lists depending on 1 cell value | Excel Discussion (Misc queries) | |||
how to add two data validation lists to a single cell? | Excel Worksheet Functions |