Excel functionality for returning values

Hi all,  I am trying to create a dashboard where if a state is selected from a drop-down and the company supports that state, it will return the company name.  Basically, my data table is below.  I...