Excel formula

angie -  
Vaucluse Messages postés 27336 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?

1 réponse

  1.
    Vaucluse Messages postés 27336 Date d'inscription   Statut Contributeur Dernière intervention   6 453
     
    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