Vlookup subtraction from a cell

[damagas]

Hi guys,

I have a problem here solving something simple. From my VLOOKUP table there is multiple codes with numbers i need those numbers to subtract from particular cell. I have a formula =B2-VLOOKUP(A2,Process!G:H,2,FALSE). G is my code, H is my numbers. The first value from the VLOOKUP table will subtract but there is more to be subtracted but it wouldn't. How to make G:H continuously subtract from B2 ?

Thanks

[Fotis1991]

Perhaps using SUMPRODUCT. Can you upload a small sample workbook?

[Debraj Roy]

Try This..

Please Login or Register  to view this content.

[damagas]

It's the actual work book. Please see what you can do. Thanks

[damagas]

Thanks Roy but it doesn't work. I need a vlookup to identify from witch cell the number has to be subtracted. Thanks

[Fotis1991]

......................................

[Fotis1991]

=B2-SUMIF(Process!$E$2:$E$20,D2,Process!$F$2:$F$20) ???

[damagas]

Fotis1991. There is two sheets i need from stock b2 do a subtraction of bags used in process G:H

[damagas]

Thats perfect fotis!! It works! I just had to change some cells but it works alright! Thank you very much!!!!

[Fotis1991]

.........................

[Hhkmung]

I have the same challenge but can't view post for reference.

I've registered.

[AliGW]

Administrative Note:

Welcome to the forum.

We are happy to help, however whilst you feel your request is similar to this thread, experience has shown that things soon get confusing when answers refer to particular cells/ranges/sheets which are unique to your post and not relevant to the original.

Please see Forum Rule #4 about hijacking and start a new thread for your query.

If you are not familiar with how to start a new thread see the FAQ: How to start a new thread