Excel formula
Bonjour,
I am working with an inventory sheet.
Worksheet A has the inventory count, Worksheet B has my orders and bi info.
When my qty in stock is decreased in Worksheet B after picking an order, How do I carry that result over to Worksheet A into the qty in stock column?
I am working with an inventory sheet.
Worksheet A has the inventory count, Worksheet B has my orders and bi info.
When my qty in stock is decreased in Worksheet B after picking an order, How do I carry that result over to Worksheet A into the qty in stock column?
1 réponse
-
Contributeurwithout knowing your data, it's not easy to answer you!
Perhaps you can use VLOOKUP like here:
with sheetB:
column A:A: name of product
column B:B result of stock
with sheet A
column A:A: name of product (begining on row2)
column B:B this formula:
=VLOOKUP(A2;sheetB!A:B;2;0)
If it's not correct, put a model of your data here and come back with the net adress.
Waiting for reading you
Ps: sorry for my english... i'm not very good in Excel, but it' worst in english langage
