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.



    [COLOR="#B22222"]EDIT BY MODERATOR[/COLOR]
    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.
    Thanks.

Participate now!

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