If name = one in the list then x - y; Help me please!

**damagas** · 06-13-2013, 05:12 AM

Hi guys,

I'm doing this Process/Stock sheet and I'm trying to find a way to subtract what ever was used from stocks. For example: 10 boxes of type 'A' were used - stock is 20. 30 boxes of type 'B' were used - stock is 40. Sounds simple ,but the problem is there is so many types that I had to make a drop down list and from there I wanted the values to come up automatically, but I don't know how to get a field to recognize witch value has to be taken. Please Help Me!!

Thanks!

**Fotis1991** · 06-13-2013, 05:22 AM

Like this?

**:) Sixthsense :)** · 06-13-2013, 05:24 AM

In J2 Cell

Formula:

Please Login or Register  to view this content.

In M2 Cell

Formula:

Please Login or Register  to view this content.

In N2 Cell

Formula:

Please Login or Register  to view this content.

**damagas** · 06-13-2013, 06:54 AM

Thanks guys but now I have a problem that the stock list wouldn't update after subtraction. That means that the next time we're doing the same packaging its going to subtract from old stock.