Data matching with data validation

Hi,

I've got a worksheet just for logging our work issues. I have a column called STATE with a drop down data validation of all the state abreviations, and a column of FORM ID also with a drop down of all the IDs. I would like to be able to choose a STATE and on the FORM ID column will show me a result of all the IDs for that particular STATE, so i can choose which ID i can use for that STATE. Is this possible? I'm a attaching a sample. Thank you!