Pricing tool

[Jambob23]

Hi i have basic excel knowledge. I am trying to create a prcing tool for selling laptops (for context) so i want a tool where i cant input all my component prices (differnet ram, hdd etc) then i want to enter my basic unit price, then have drop downs, for each component, it will take the cost from my table and give me total price?? Any ideas how to do this?

 

[Logit]

.
One method using Dependent Dropdown lists :

https://chandoo.org/wp/dynamic-cascading-dropdowns-that-reset/