Validation cell entries (Drop-down list)

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
Nuno said:
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
Click to expand...

This sort of thing is explained very well here:
http://www.contextures.on.ca/xlDataVal02.html
 
Back
Top