Advertisement
If you have a new account but are having problems posting or verifying your account, please email us on hello@boards.ie for help. Thanks :)
Hello all! Please ensure that you are posting a new thread or question in the appropriate forum. The Feedback forum is overwhelmed with questions that are having to be moved elsewhere. If you need help to verify your account contact hello@boards.ie

Re Excel - Vlookup

Options
  • 28-08-2009 4:07pm
    #1
    Reillo
    Closed Accounts Posts: 6 ✭


    I am trying to set up a stock sheet and invoice to be tied in together on Excel. I have already used the vllokup formula to marry my stock code to my invoice, so when I enter in a stock code on an invoice i just enter the code and the description comes up automatically.

    What I want to do now is, when I enter a quantity amount on to the invoice I want it to deduct from my Stock Sheet

    Can any one please help

    Thanks
    Tagged:


Advertisement