I'm trying to set up my spreadsheet so that it will display a drop down list of the U.S. states if "United States" is selected in a specific cell, the Canadian states/provinces if "Canada" is selected, and the word "Other" if any other country is selected.
I have named the appropriate range of cells, USA and Canada. Now I'm trying to figure out what formula to use to make the data validation work. It works for everything except the value of "Other" if anything besides "United States" or "Canada" is chosen.
Any ideas on how to make it work?
Thanks!
Doug
Bookmarks