Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Validation cell entries (Drop-down list)
Hi,
I need to use a drop-down list in a range of cells of 2 columns. In the range of the 1st column, I'm using a simple data validation list for it's entries, but in the 2nd column, I need to get a list with some conditions. For example: If A1= Costs B1 only can be ('aaa', 'bbb' or 'ddd') If A1= Income B1 only can be ('ccc', 'eee' or 'fff') At the moment, at the Data Validation Settings (Source:), I'm using IF conditions, but the formula is getting too large (and I need to insert more conditions), I've tried to use SUMPRODUCT but it gives me an error! Can you help me? Thanks Nuno Belo |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Validation cell entries (Drop-down list)
You can create dependent dropdown lists, as described he
http://www.contextures.com/xlDataVal02.html Nuno wrote: Hi, I need to use a drop-down list in a range of cells of 2 columns. In the range of the 1st column, I'm using a simple data validation list for it's entries, but in the 2nd column, I need to get a list with some conditions. For example: If A1= Costs B1 only can be ('aaa', 'bbb' or 'ddd') If A1= Income B1 only can be ('ccc', 'eee' or 'fff') At the moment, at the Data Validation Settings (Source:), I'm using IF conditions, but the formula is getting too large (and I need to insert more conditions), I've tried to use SUMPRODUCT but it gives me an error! Can you help me? Thanks Nuno Belo -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Validation cell entries (Drop-down list)
"Nuno" <Portugal wrote in message
... Hi, I need to use a drop-down list in a range of cells of 2 columns. In the range of the 1st column, I'm using a simple data validation list for it's entries, but in the 2nd column, I need to get a list with some conditions. For example: If A1= Costs B1 only can be ('aaa', 'bbb' or 'ddd') If A1= Income B1 only can be ('ccc', 'eee' or 'fff') At the moment, at the Data Validation Settings (Source:), I'm using IF conditions, but the formula is getting too large (and I need to insert more conditions), I've tried to use SUMPRODUCT but it gives me an error! Can you help me? Thanks Nuno Belo This sort of thing is explained very well he http://www.contextures.on.ca/xlDataVal02.html |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Validation cell entries (Drop-down list)
Perfect! Thanks
"Stephen" wrote: "Nuno" <Portugal wrote in message ... Hi, I need to use a drop-down list in a range of cells of 2 columns. In the range of the 1st column, I'm using a simple data validation list for it's entries, but in the 2nd column, I need to get a list with some conditions. For example: If A1= Costs B1 only can be ('aaa', 'bbb' or 'ddd') If A1= Income B1 only can be ('ccc', 'eee' or 'fff') At the moment, at the Data Validation Settings (Source:), I'm using IF conditions, but the formula is getting too large (and I need to insert more conditions), I've tried to use SUMPRODUCT but it gives me an error! Can you help me? Thanks Nuno Belo This sort of thing is explained very well he http://www.contextures.on.ca/xlDataVal02.html |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Create list of unique entries for use in validation | Excel Worksheet Functions | |||
BUG? : data validation in-cell drop down list is not displaying | Excel Discussion (Misc queries) | |||
View all entries in Validation List | Excel Discussion (Misc queries) | |||
blank entries in data validation list | Excel Worksheet Functions | |||
Default Cell Value with Validation Drop-Down List | Excel Discussion (Misc queries) |