Report

Formula [Solved]

Ask a question krissannidhi 2Posts Friday February 26, 2016Registration date February 26, 2016 Last seen - Last answered 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

Member requests are more likely to be responded to.

Members can monitor the statuses of their requests from their account pages.

A CCM membership gives you access to additional options.

Not a member yet?

Sign up now. It takes less than a minute and is completely free!