Previous Topic Next Topic

Formula

Solved/Closed
krissannidhi Posts 1 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 response

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

Similar discussions

How to calculate positions (1st,2nd,3rd...) in Excel
hardy -
TrowaD -

6 responses
How to calculate position (1st,2nd,3rd) in excel....?
abdulwajid -
TrowaD -

1 response
Calculation of positions in excel
Mohsin -
Dausayi -

12 responses
formulas for 1st and 2nd position in class
jack -
suff954 -

1 response