Excel formula
angie
-
Vaucluse Messages postés 26496 Date d'inscription Statut Contributeur Dernière intervention -
Vaucluse Messages postés 26496 Date d'inscription Statut Contributeur Dernière intervention -
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?
A voir également:
- Excel formula
- Liste déroulante excel - Guide
- Formule si et excel - Guide
- Formule moyenne excel plusieurs colonnes - Guide
- Word et excel gratuit - Guide
- Formule somme excel colonne - Guide
1 réponse
without 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
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