Spreadsheet subtract lists

Docs
1

This is for inventory management.

I have two columns in the inventory spreadsheet that look like this:
f1 2
f2 34
f3 1
f4 5
f5 12
g1 6
g2 13
g3 12
m1 9
m2 4

and each day I have a second spreadsheet with what I should remove from the inventory that looks like this:
f1 1
f2 21
g2 2
m2 6

So the second spreadsheet contains a few of the variables of the first spreadsheet, each with its own number that has to be subtracted.

What i want is for the numbers in the second column of the first spreadsheet to automatically compute.

Is this possible?

2

Hello @testgcd

This is purely depends on the design of your sheets. For instance, you can simply use formula =Cell1-Cell2 to subtract. Here is an example on how to use it with several sheets:

=B2-Sheet2!B2

It will subtract values of the same cells, but in different sheets.