If statement, need solution

[Tommy753]

[Use drop down selecting Quartz, Granite or solid surface (Drop down created) Cause price on left to populate price cell. Help would be appreciate finding a formula
[TABLE="width: 1241"]
<tbody>[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="colspan: 3"][/TD]
[TD][/TD]
[TD="colspan: 4"][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="colspan: 3"]Quartz Drop down select type[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="colspan: 3"][/TD]
[TD][/TD]
[TD="colspan: 3"]Quartz Price $$$$$

Granite Price $$$$

Solid Surface Price $$$$[/TD]
[TD][/TD]
[TD="colspan: 6"][/TD]
[TD][/TD]
[TD]Copy to PriceCell $$$[/TD]
[TD="colspan: 3"][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="colspan: 17"][/TD]
[TD][/TD]
[TD][/TD]
[TD="colspan: 3"][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

 

[jtakw]

You're welcome, glad you got it working.