I am putting together a list, and want to use validation features in most of
the Columns to limit choices for individuals to enter. My problem is that, a
choice for Column A, limits what choice you can use in Column B. For
instance, let's say Column A has two choices, "USA" or "Canada", based on
which is chosen, the next choice for "USA" chould be "New York", "Texas",
etc., whereas for "Canada", the next choice could be "Alberta" , "Ontario",
etc. Even using an equation doesn't seem to help, for how can I apply
=IF((A1)="USA",[Validation List for USA],IF(A1)="Canada",[Validation List for
Canada],"Please Pick Country in Column A")), when I still need to use the
list.

Any ideas?