Dynamic lookup using data from multiple dropdowns

Hello. I have a workbook with three sheets, Sub List, Approved Contractors and Legend. On my subs sheet, I have two dropdowns in A2:A7 and C2:C7. Column A dictates what type of sub contractor is needed and column C provides a list of appropriate contractors. I have named ranges that I would like to do lookups in to populate D:G based on the chosen contractors. The named range of the contractor being looked up would be the type craft name immediately followed by a number. In the attached example I supplied the expected results in D3:G3 based on "National Surface Cleaning" being the chosen sub in C3. I thought I could make something work using Indirect and Match along with Concat and text to add A2 and the number 2 together for determining the named range, but everything I try seems to error out.