Database Spreadsheet with Multiple Variables

I am trying to build a spreadsheet that would allow me to prepare a conceptual cost estimate for construction. The problem I am having is that there are two databases to chose from based on the construction type. If the Construction Type selected is "Remodel" then the pricing should be based on one database, if the Construction Type selected is "New" or "Addition" then pricing is based on the other database.

To complicate things is that I am asking the client to select priorities for items, "1" being Low Priority, "2" being Medium Priority, and "3" being High Priority. These then drive the costs being used to calculate a project cost.

I am having a difficult time putting this all together. I have the formulas for the Priorities, but can't seem how to integrate the Construction Type question as a driver for the unit costs.

Any suggestions? I have attached the spreadhseet

Sorry,

Attached is a cleaner copy of the spreadsheet. Priorities tab, Cell L3 contains the selection for construction type.

Thank you

Mahju

Thank you for your assistance! This is exactly what I was trying to achieve.

MVWest Michigan