Sujet Précédent Sujet Suivant

Excel formula

Fermé
angie - 20 nov. 2017 à 16:17
Vaucluse Messages postés 26496 Date d'inscription lundi 23 juillet 2007 Statut Contributeur Dernière intervention 1 avril 2022 - 20 nov. 2017 à 17:54
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?



1 réponse

Réponse 1 / 1
Vaucluse Messages postés 26496 Date d'inscription lundi 23 juillet 2007 Statut Contributeur Dernière intervention 1 avril 2022 6 418
20 nov. 2017 à 17:54
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
0