Proposal spreadsheet that will calculate cost based on input

[windowman]

I want to create spreadsheet I can use to calculate the price of my product, windows. A proposal I can give to my customer.

Price is determined by 4 variables, 1. style of window, 2. Installation type, 3. color, and 4. size. There are 8 styles of windows, 2 install types, 3 color and 10 different size catagories. Each window style has 60 different possible prices based on above info.

In simple terms, instead of manually looking up the price based on these items I want to be able to enter

Double Hung insert installation single color 85 inches

into a spreadsheet

and based on those 4 cell entries I want a formula in my price column to pull the correct price from another spreadsheet and have it automatically entered into the price cell.

Thank you
Mike

 

[P Sitaram]

Please give the layout of the other spreadsheet that holds the price data.