By changing shape code formula should change

[Syed Mohammad Ali Quadri]

Dear Chandoo
I very hopeful that you can resolve my problem; I have enclosed my working sheet to explain you my problem
There is Shape Code from 20 to 87 having different formulas in Column "W and Y"; In calculation space there is also Shape code Column "H" I want to calculate length of bars as per Shape Code in Column "I" as per formula given in Column Y of same shape Code, means if I change shape code in column "H", formula should change in Column "I", as given in Array W2:Y28
I hope you, understand my problem
Thanks and Regards

Syed Quadri

 

[Faseeh]

Hi Ali,

Please see if attachment fulfills your needs.

 

[Syed Mohammad Ali Quadri]

Thanks Faseeh
I will work on it and then I will let u know
Regards
Syed Quadri