Thank you for the links, unfortunately none of which help resolve the issue I am having.

Heres an examples.

First drop down list is states

Illinois
Michigan
California

Based off of the users selection the second drop down list gives a list of cities in the state.

I want the 3rd drop down list to give a list of vendors that are in that state but not particularly from that city. I NEED it to be based off of the 1st column still like col 2.

**data is just an example- it is not the actual data I am using. Thanks