Problems with excel formula AND

[krù]

Hello everybody!

I'm having some problems with a formula I entered in excel.

I have a table made of 8 rows in which I have names of companies and 1
columns in which I have their products. These products are divided int
3 groups, called A, B and C; which one have up to 5 products
Unfortunately not all companies have all products so that I have som
empty cells.

I created 3 combo box: the first one is made for choosing the compan
name; the second one is for the product group and finally, the last i
for the specific product.

The result should be that, choosing the company name, only th
group/groups it makes shows; then, choosing the group, only th
products of that company and of that group are shown.

I wrote:

=IF(AND($G$11=1;$J$11=1;DRIVERS!C$200;IF(AND($G$11=2;$J$11=1;DRIVERS!C$201;IF(AND($G$11=3;$J$11=3;DRIVERS!C$202;IF(AND($G$11=4;$J$11=1;DRIVERS!C$203;IF(AND($G$11=5;$J$11=1;DRIVERS!C$204;IF(AND($G$11=6;$J$11=1;DRIVERS!C$205;IF(AND($G$11=7;$J$11=1;DRIVERS!C$206;IF(AND($G$11=8;$J$11=1;DRIVERS!C$207)))))))))))))))

But, of course, there is an error!

What can I do?

Please reply, if any expert knows the solution!

Thank you

Ciao

Kr

 

[Andy B]

Hi

Have a look here:
http://www.contextures.com/xlDataVal02.html
This will show you how to make Data Validation work with dependent lists

 

[Bob Phillips]

I have a sample workbook for control toolbox combos. Give me your email
address if you want a copy.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)