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!