Multiple Combo Box Query
 

I have read most of the postings for combo box set up, but I think my issue
is a bit different.

I am trying to put together a contact list based on specific issues for
multiple plant sites. The idea is an employee chooses his/her local plant
site from a drop down box in column A, then chooses the issue in column B and
the contact name appears in column C, and the number associated with the
answer in column C appears in column D

I am putting the lookups on sheet 2, but I can't quite figure out how to lay
out the lookups to get the boxes to work correctly.

Can anyone help?