Data Validation
 

Hi I am trying to write an IF Statement for a drop list that depends on
another drop list:

If I choose one option in the first drop down list, the corresponding
options will appear in another drop down list, I was trying IF in Data
Validation Settings Custom, but it s not working, any suggestions?

Thanks a lot!

Data Validation
 

See this excellent site:

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

"Jean" wrote:

Hi I am trying to write an IF Statement for a drop list that depends on
another drop list:

If I choose one option in the first drop down list, the corresponding
options will appear in another drop down list, I was trying IF in Data
Validation Settings Custom, but it s not working, any suggestions?

Thanks a lot!