Dependent Drop Down List

P_Bennett,

Attached is a modified version of your posted workbook. It contains the following changes:

1. Sorted the Projects table by project.
2. Created a named range "ProjectList" using formula:
   

   =Table_Query_from_COMPASS_APP[project]

3. Sorted the Subcontracts table by project and then by subcontract.
4. Created a named range 'SubContractList' using formula:
   

   =Table_Query_from_COMPASS_APP3[project]

5. Used the ProjectList named range as the data validation list for sheet 'Data Entry' cells A6:A13
6. Created a data validation list in sheet 'Data Entry' cells D6:D13 by using this formula:
   

   =IF($A6="","",OFFSET(SubContractList,MATCH($A6,SubContractList,0)-1,1,COUNTIF(SubContractList,$A6)))

7. Retrieved the Subcontract Name in sheet 'Data Entry' cells E6:E13 by using this formula:
   

   =IF(OR(A6="",D6=""),"",INDEX(Table_Query_from_COMPASS_APP3[Name],MATCH(1,INDEX((Table_Query_from_COMPASS_APP3[project]=A6)*(Table_Query_from_COMPASS_APP3[subcontract]=D6),),0)))