subtract data using match and vlook

dear Expert
i would like subtract data as in attached file
in Cell D14 & D15 which look to matched data from B14 and B15 to list A2:A9

Try this in D14 filled down to D15.

=VLOOKUP(B14,$A$2:$E$8,5,0)-C14

please see my attahced file that give me error with some modification

@mazan2010

In the last book you posted, Change the 5 to a 7, and the 8 to a 9.

please see my attached file that although withdraw two time from the same product but it give same number as the first time is withdrawed

its also give me error

You keep changing stuff.

In your attachment from Post #3, formula in Cell D14 was
=VLOOKUP(B14,$A$2:$G$8,5,0)-C14

I suggested chaning the 5 to a 7 and the 8 to a 9
But you put this in the next attachment from post #7
=VLOOKUP(B14,$A$2:$E$8,7,0)-C14

You Also changed the G to an E for some reason.. Why?

The formula in D14 should be
=VLOOKUP(B14,$A$2:$G$9,7,0)-C14

its the same problem
meaning with if i withdraw any future quantity its subtract as first time for withdraw

please see my attached file with highlight

D14 and filled down

=VLOOKUP(B14,$A$2:$G$9,7,0)-SUMIF($B$14:$B14,B14,$C$14:$C14)

its work now thanks Jonmo1

How to disable N/A error in this formula

=iferror((vlookup(b14,$a$2:$g$9,7,0)-sumif($b$14:$b14,b14,$c$14:$c14)),"")

You're welcome.