J
jflatt95
I have data in column C, that has to be processed through one of 3 possible
equations (which is inputted in column D). In column D, I am using VLOOKUP to
look at column C, and then pull the right equation into column D. However, my
issue is that my equations are set something like (=0.0456*x). So in column E
instead of getting my values, I just get the equation.
I would like to know how I can get column D, to pull in the data it needs
(ie the value of x) from column C (ie the data in column C = x (in the
equation)).
So what I should have then is
Column C Column D Column E (Value from the
chosen
Data Which equation to use equation and data)
equations (which is inputted in column D). In column D, I am using VLOOKUP to
look at column C, and then pull the right equation into column D. However, my
issue is that my equations are set something like (=0.0456*x). So in column E
instead of getting my values, I just get the equation.
I would like to know how I can get column D, to pull in the data it needs
(ie the value of x) from column C (ie the data in column C = x (in the
equation)).
So what I should have then is
Column C Column D Column E (Value from the
chosen
Data Which equation to use equation and data)