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
formula's in sheet 2 in the highlighted cells.......
Steve
"Nearly all men can stand adversity, but if you want to test a man's character, give him power."
-Abraham Lincoln
I presume you mean for a particular symbol?
=VLOOKUP(A2,Sheet1!A:C,2,FALSE)-VLOOKUP(Sheet1!A2,Sheet1!A:C,3,FALSE)
____________________________________________
Nihil simul inventum est et perfectum
Abusus non tollit usum
Last night I dreamed of a small consolation enjoyed only by the blind: Nobody knows the trouble I've not seen!
James Thurber
You're probably right Bob.....I think I misunderstood the requirement....
Steve
"Nearly all men can stand adversity, but if you want to test a man's character, give him power."
-Abraham Lincoln
Thanks for the help. I ran a test and it works super.
Max
Posting Permissions
Reply With Quote
