I'm trying to figure out a way to change the list that appears in a cell's
drop-down menu based on some IF statements. I have defined several different
named ranges that define my lists. Normally I would go to data validation
and enter the name there to form my drop down menu. In this case, though, I
want to make "rangeA" apply for my input value being less than 100, and
"rangeB" apply for when the value is greater than 100. Is there a way to do
this using data validation, or will I need to try a control drop-down with VB
coding?

Take a look he


http://www.contextures.com/xlDataVal02.html


In article ,
DPR wrote:

I'm trying to figure out a way to change the list that appears in a cell's
drop-down menu based on some IF statements. I have defined several different
named ranges that define my lists. Normally I would go to data validation
and enter the name there to form my drop down menu. In this case, though, I
want to make "rangeA" apply for my input value being less than 100, and
"rangeB" apply for when the value is greater than 100. Is there a way to do
this using data validation, or will I need to try a control drop-down with VB
coding?