Excel order form quantity unit price amount total

  • Hello,

    I am creating an order form where the order total is contingent on quantity and unit price (volume discounts), but I can't figure out how to use the VLOOKUP function to use two variables: 1) Which item the user chooses , and 2) Which quantity is supplied by the user.

    I am attaching a template that I am working on for your review and help.

    Thank you for any help in formulating the function. Also , once you do it please explain to me how it works and functions so I know how to modify it in the future.

    Thank you in advance!
    GuyV :)

  • Re: Excel order form quantity unit price amount total

    bump , any insight on this is appreciated.

    Please allow 18-24 hours before bumping your thread. This is a free help forum and all help is voluntary based on willingness, knowlede and presence on the board.

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!