Previous Topic Next Topic

Formula

Solved/Closed
krissannidhi Posts 2 Registration date Friday February 26, 2016 Status Member Last seen February 26, 2016 - Feb 26, 2016 at 07:01 PM
 RayH - Feb 26, 2016 at 09:11 PM
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

1 reply

Answer 1 / 1
RayH
Feb 26, 2016 at 09:11 PM 
=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
0