Autofill or Dropdown based on a filter

I have a set of customer data that has grown too long.  Had it as a single drop down but want to limit the drop down selection based on a second criteria,  For example purposes, let's use state as th...