Display Values based on 2 separate List Menus

I need to displays values (Equipment P/N & Descriptions) based upon 2 separate list values.

I have a sheet (Mfg Data) that the data is sorted by Mfg and then by product type and finally by P/N & Description. So A5:E:65 is data for the 1st manufacture, A70:E130 is the 2nd Manufacture and A135:E195 is the 3rd Manufacture.

I have sorted the information by columns, RowB is the Manufacture, RowC is the Product Type, Row D is the Descrptions, RowE is the PN.

So think of it this way:
........A......B........C......D........................E
6..............ABC Company
7........................Wall Based Equipment
8................................Description 1........PN 01
9................................Description 2........PN 02
10..............................Description 3........PN 03
11..............................Description 4........PN 04
12..............................Description 5........PN 05
13......................Ceiling Based Equipment
14..............................Description 6........PN 06
15..............................Description 7........PN 07
16..............................Description 8........PN 08
17..............................Description 9........PN 09
18..............................Description 10......PN 10

65.............123 Company
66.....................Wall Based Equipment
67..............................Description 11......PN 11
68..............................Description 12......PN 12
69..............................Description 13......PN 13
70..............................Description 14......PN 14
71..............................Description 15......PN 15
72....................Ceiling Based Equipment
73..............................Description 16......PN 16
74..............................Description 17......PN 17
75..............................Description 18......PN 18
76..............................Description 19......PN 19
77..............................Description 20......PN 20

B6 is "ABC Company", Cell C7 is product type and D8:D13 is the description, E8:E13 is the P/N and etc down the various manufactures, product types & descritions

I have created 2 named ranges: (BTW: when I select ignore blanks in the validation, it does'nt)
NAC_Mfg (which has 3 options)
NAC_Type (Which has 7 options)

So I have a potential of 126 separate values to display (3 NAC_Mfg x 7 NAC_Type x 6 (Descriptions/PN))

Now onto the next step....
On a separate sheet (Product List) in C3 is a list menu for the named range "NAC_Mfg", and in C4 is a list menu for named range "NAC_Type",. Now based on these 2 lists, Cell C6 needs to display a certain value. So if C3 is selected for "ABC Company and C4 is selected for "Wall Based Equipment", then I need C8:C12 to display the information inputed in D8:D12 from the 'Mfg_Data' sheet. Or if C3 is slected for "123 Company" and C4 is selected for "Ceiling Based Equipment" then I need C8:C12 to display D73:E77 the information inputed in D8:D12 from the 'Mfg_Data' sheet

So, how do I do this....

Any help is appreciated...

Thanks
BV