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

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

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

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