Report

Formula [Solved]

Ask a question krissannidhi 2Posts Friday February 26, 2016Registration date February 26, 2016 Last seen - Latest answer on Feb 26, 2016 09:11PM
Hi
please I am looking for a formula to get difference between 2 sheets
example
sheet 1 sheet 2
ndc quantity ndc quantity difference
11111 10 11111 5
22222 20 22222 15
33333 30 33333 45
44444 40 44444 65
I need a formula to calculate difference in quantity with same ndc
thanks for your help
See more 
Helpful
+0
moins plus
=VLOOKUP(A2,Sheet1!A2:B2,2,FALSE)-B2


or
=B2-VLOOKUP(A2,Sheet1!A2:B2,2,FALSE)


depending on which way you wan to do the calculation
Add comment

Members get more answers than anonymous users.

Being a member gives you detailed monitoring of your requests.

Being a member gives you additional options.

Not a member yet?

sign-up, it takes less than a minute and it's free!