Multiple formulas given a formula code

[sugarplant]

I have a table similar to the following, where I have to calculate column E depending on what the equation code is in column A. Different equations require different variables, which are listed in columns B, C, and D. Is it possible to do some sort of VLOOKUP in E that can have a different formula depending on the Equation code in Column A? I have about 19 different equations, so trying to avoid a nested IF function. Thanks!!

	A​	B​	C​	D​	E​
1	Equation #	X	Y	Z	Result
2	WW.1	1		4	??
3	WW.2		2		??

 

[diddi]

hi and welcome to MrExcel
this sounds like a simple macro task to me. i think you are prolly right in expecting a horrible nested formula if you use normal sheet formulae.
have you done anything with macros

 

[sugarplant]

Thanks! I was trying to avoid macros, but if I must I must. I've just been managing macros by copy pasting code from similar solutions I find here, but I haven't seen anything on my particular problem. Any suggestions?

 

[diddi]

i can help with this. post some of the formulae as examples

 

[sugarplant]

They're a bit complicated as there are lots of constants, but i've simplified them. I'll replace the constants on my own.:

WW.1 = X * 99
WW.2 = Y*Z*99

The initial table just had place holder numbers. Here are some "actual" values.
For WW.1, X= 1,000
For WW.2, Y = 1,000 and Z = 800

Would the macro be very different depending on the formula? or can i just replace the formulae as needed.