Formula [Solved/Closed]

Report
Posts
2
Registration date
Friday February 26, 2016
Status
Member
Last seen
February 26, 2016
-
 RayH -
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

=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