Data validation drop down list using if statement in table?

Hi,

So i have a table on a secondary sheet, with colums as below, but with nearly 100 rows of data. States have 5 different set values (ACT, NSW, QLD, etc), type has 4 (print, web, tv, radio). Obviously then the names and contact details are all different.

State	Type	Name	Contact
ACT	Print	John smith	123456789
NSW	TV	Jane Smith	987654321

What i would like to do is in a data validation list (drop down) on my primary sheet, is to have the data validation for that specific cell, search and show in the list only the data from a specific state and type. Say state = ACT and Type = print and then my data validation list would only display the names relevant to that criteria?

Basically i want to set up a drop down to only show me the ACT Print names. and another drop down to show me the ACT web names. etc.