View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
jflatt95 jflatt95 is offline
external usenet poster
 
Posts: 1
Default Excel Equation Help

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)