Drop down lists

[Carrie]

Hi,
I have created a drop down lists with following formula (linked to multiple
named rows) so if say cell D17 was 20 then it would return a range of numbers
to select in drop down relating to a certain list (twenty.one).
=IF(D17="20",twenty.one,IF(D17="22",twentytwo.one,IF(D17="30",thirty.one,IF(D17="40",forty.one))))
This works but I need to add an AND in to the formula and when I try I just
get an error. Is it possible to put in an AND in validation?
Many thanks.

 

[T. Valko]

What is the "AND" condition?

Biff

 

[Carrie]

I wanted it to look at a second cell as a reference but this is too many
arguments so I am going to try and work another way around it.
Thanks.

 

[shail]

Hi Carrie,

You need to put the AND formula in this way -

=IF(AND(A1=17,A2=0),mm,cc)

This is just an example. Put the formula into the validation dropdown
list.

Hope that Helps,

Thanks
Shail

 

[shail]

=IF(AND(A1=17,A2=0),mm,cc)

here mm and cc are range names.