Validation cell entries (Drop-down list)

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
 
S

Stephen

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Combining Data 1
Filtering Based in a cell value 2
Can't located named range 3
Size of drop down in validation list 2
Drop down list based on choice of another dropdown 2
Complicated mail merge 1
Data Validation and drop-down list using IF, AND and what else? 8
Data validation list using filtered range 3

Top