formula Solved/Closed

Question

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

RayH · Answer

=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

Formula

1 response

Similar discussions

Subscribe To Our Newsletter!