Cascading Dropdowns from table

After I select a room from the SETUP tab, I would like to

1. Have column B with a dropdown of the unique values of the CATEGORY column of the Price_Table

2. Dependent on the CATEGORY selected, the dropdown values in the SUB-CATEGORY would reflect only those values related to the CATEGORY field

3. Based on the two previous dropdowns, the final dropdown would contain only those items that relate to the specified CATEGORY and SUBCATEGORY fields

Expected Behavior:

1. B4 dropdown should contain (Cabinets, Counertops, Hardware)
2. Select Countertops in B4
3. C4 dropdown should contain (Solid Surface, Plam)
4. Select SOLID SURFACE in C4
5. D4 dropdown should contain (Solid Surface Countertop, Solid Surface Wall Protection)
6. Once D4 is selected the UNIT, UNIT COST, should populate from the table information.

I hope this explains the information in enough detail. I've seen solutions where the categories are in separate lists, but never in a combined table.

Thanks for any help