Evaluate a formula contained in a different cell

I would like to set up a spreadsheet to be used for making price quotes and/or sales orders. The sheet would have pricing formulas defined for a number of different product types. I would like to be able to evaluate these pricing formulas wherever that product type is listed on the quote. The formula would have absolute references to the Base and Variable price in the definition, but a relative reference for the variable.

My price formulas would look something like this:

	A	B	C	D	E
1	Product Type	Base Price	Variable Price	Variable	Price
2	Type A	200	50		=$B$2+$C$2*D2
3	Type B	300	60		=$B$3+$C$3*D3

The Sales order itself would look like this:

	A	B	C
1	Product Type	Variable	Price
2	Type A	x	=(evaluate price for chosen product type and variable)
3	Type B	y	=(evaluate price for chosen product type and variable)
4	Type B	z	=(evaluate price for chosen product type and variable)

Note: I have gotten this concept to work with an exceedingly complex IF/ELSE formula. It is very difficult to add new price definitions for new products. Anyone have any ideas to make my life a little simpler?

I've attached a spreadsheet containing working price definitions.

I presume x y and z are meant to be numbers - if so you can use this formula in J4:

=VLOOKUP(H4,$B$4:$C$5,2,0) + VLOOKUP(H4,$B$4:$D$5,3,0)*IF(ISNUMBER(I4),I4,0)

then copy down.

Hope this helps.

Pete