Referencing data validation list in IF Statement
 

Is there a way to referece a data validation list name in an IF statement?
Say I have a data validation list in cell A1. In Cell B1, I want to pull in
a certain IF statement from another cell depending on what data validation
list is in cell A1.

So - I have List "New York" in A1 which includes Buffalo, Rochester, Albany
and Brooklyn, and the if statement associated with that list is
=if(a1="Buffalo","WNY",if(a1="Rochester","CNY,if(a 1="Albany","NENY","NYC")))

If I change the list to "California", which includes Los Angeles, Napa
Valley and San Francisco, my thought was to put the associated if statements
in some reference cell (say a100, a101, etc.), then use an IF statement in B1
to say =if(datavalidation list = "New York",a100,if(datavalidation list
="California,a101....etc. But I don't know how to, or if I can, reference a
named list like this.

Thanks.

Referencing data validation list in IF Statement
 

I'm thinking you need something like this

http://www.contextures.com/xlDataVal13.html
--
HTH,
Barb Reinhardt




"PMarble" wrote:

Is there a way to referece a data validation list name in an IF statement?
Say I have a data validation list in cell A1. In Cell B1, I want to pull in
a certain IF statement from another cell depending on what data validation
list is in cell A1.

So - I have List "New York" in A1 which includes Buffalo, Rochester, Albany
and Brooklyn, and the if statement associated with that list is
=if(a1="Buffalo","WNY",if(a1="Rochester","CNY,if(a 1="Albany","NENY","NYC")))

If I change the list to "California", which includes Los Angeles, Napa
Valley and San Francisco, my thought was to put the associated if statements
in some reference cell (say a100, a101, etc.), then use an IF statement in B1
to say =if(datavalidation list = "New York",a100,if(datavalidation list
="California,a101....etc. But I don't know how to, or if I can, reference a
named list like this.

Thanks.

Referencing data validation list in IF Statement
 

Thank you, Barb - that did it!

"Barb Reinhardt" wrote:

I'm thinking you need something like this

http://www.contextures.com/xlDataVal13.html
--
HTH,
Barb Reinhardt




"PMarble" wrote:

Is there a way to referece a data validation list name in an IF statement?
Say I have a data validation list in cell A1. In Cell B1, I want to pull in
a certain IF statement from another cell depending on what data validation
list is in cell A1.

So - I have List "New York" in A1 which includes Buffalo, Rochester, Albany
and Brooklyn, and the if statement associated with that list is
=if(a1="Buffalo","WNY",if(a1="Rochester","CNY,if(a 1="Albany","NENY","NYC")))

If I change the list to "California", which includes Los Angeles, Napa
Valley and San Francisco, my thought was to put the associated if statements
in some reference cell (say a100, a101, etc.), then use an IF statement in B1
to say =if(datavalidation list = "New York",a100,if(datavalidation list
="California,a101....etc. But I don't know how to, or if I can, reference a
named list like this.

Thanks.