PDA

View Full Version : Using Sheet1 and Sheet2



Tenspeed39355
10-28-2007, 07:06 AM
Good Morning guys. In Sheet1 I have column one for the symbol. In columns 2 and 3 I have some numbers. In Sheet 2 I would like to make a formula showing the difference between the two columns in Sheet 1. What formula would I use? Thanks for your help with this as I am drawing
a blank.
Max

lucas
10-28-2007, 07:17 AM
formula's in sheet 2 in the highlighted cells.......

Bob Phillips
10-28-2007, 07:45 AM
I presume you mean for a particular symbol?

=VLOOKUP(A2,Sheet1!A:C,2,FALSE)-VLOOKUP(Sheet1!A2,Sheet1!A:C,3,FALSE)

lucas
10-28-2007, 07:49 AM
You're probably right Bob.....I think I misunderstood the requirement....

Tenspeed39355
10-28-2007, 10:36 AM
Thanks for the help. I ran a test and it works super.
Max