Excel - Stock List Calculation

I will try to explain what i need to accomplish

I have a little firm. I work with stone. I order new material every once in a while and i want to keep track of it. In table X i keep track of everything i get from supplier. (1 - type of stone, 2- dimensions, 3- quantity, 4- quantity that will change).

I take 1 stone to work on it (i choose stone id 1 - žgano with dimensions 180/200)

In the Y table i would then select id 1 (which will link to the stone i took to work on from table X) input the dimension of the new stone that remains to work on another project and it would deduct the value from the real quantity in table X.

I hope you understand now .

Ok so I have attached a workbook with example. The cells marked in yellow are the one that changed- The real quantity values were deducted based on entry in the table two.

Best regards

Administrative Note:

Welcome to the forum.

We would very much like to help you with your query, however the thread title does not really convey what your request is about. Tell us what you are trying to do, not how you think it should be done.

Please take a moment to amend your thread title. Make sure that the title properly explains your request. Your title should be explicit and not be generic (this includes function names used without an indication of what you are trying to achieve).

Please see Forum Rule #1 about proper thread titles and adjust accordingly. To edit the thread title, open the original post to edit and then click on Go Advanced (bottom right) to access the area where you can edit your title.

(Note: this change is not optional. No help to be offered until this moderation request has been fulfilled.)

Welcome to the forum.

There are instructions at the top of the page explaining how to attach your sample workbook.

TRY THIS
E3 cell

=IF(ISERROR(VLOOKUP(A3,H:H,1,)),D3,D3-VLOOKUP(A3,H:H,1,))

TRY
E3 cell

=D3-COUNTIF(H:H,A3)

Sorry, it doesnt work as i want it

I have make an example what values should be in the E column of table ONE after i insert the values in table TWO.

I should also do the same thing if i add values in table TWO.

Presumably you're trying to see what left-overs you have to work with after cutting something. In maths this is known as the "cutting-stock problem" & yours is 2-dimensional; which makes it a bit trickier; the more dims the more complexity!

If I remember correctly the best way to work with this is using a solver to loop through off-cuts & recycle waste.

Hopefully this gives you some steer towards more fruitful results.