Tenspeed39355
08-13-2007, 05:33 PM
Hi guys. I would like to move some data from sheet1 to sheet2.
I have tried using vlookup but I must be using the wrong formula.
Here is what I want to do. I have matching symbols in sheet2 in column A
that I have in sheet1 comumn A. What I am trying to do is the following.
If the data in Sheet1 column C is more that the data in Sheet1 column B then I want the data in Sheet1 column D to appear in Sheet2 column C.
If the data in Sheet1 column C is less that the data in Sheet1 column B then I want the data in Sheet1 column E to appear in Sheet2 column E.
I have tried using the IF statement with no luck. Any Help with this?
Thanks
Max
I have tried using vlookup but I must be using the wrong formula.
Here is what I want to do. I have matching symbols in sheet2 in column A
that I have in sheet1 comumn A. What I am trying to do is the following.
If the data in Sheet1 column C is more that the data in Sheet1 column B then I want the data in Sheet1 column D to appear in Sheet2 column C.
If the data in Sheet1 column C is less that the data in Sheet1 column B then I want the data in Sheet1 column E to appear in Sheet2 column E.
I have tried using the IF statement with no luck. Any Help with this?
Thanks
Max