I have three drop down list.

1. Country
2. State or Providence
3. Station

There are 177 countries but only "United_States" and "Canada" have States or Providences. When "United_States" or "Canada" are selected as the Country, dropdown list number 3 is dependent on dropdown list number 2. For all the other countries dropdown list number 3 is dependent on dropdown list number 1.

I have named ranges for all the countries and for all the States and Providences. I was trying to do an If then statement combined with an indirect formula in my data validation cell but I can't get it to work. I will try to get a sample file if necessary. Thanks for any help!

John