Trying to be as simple as possible here. I'm trying to make a helpful ordering tool and I want it to populate for the user based off selection and quantity. I have a sheet that I'm making to help order groceries from a master list of all groceries. For simplicity, I have 4 options I want to select from a drop down list. Attached is my basic reference file:
example.xlsx
I need a formula to do the following when the user selects the following from the list:
- Food 1 - This should place a "1" under Pizza in the list below
- Food 2 - This should place a "1" under Pizza & Tacos in the list below
- Food 3 - etc
- Food 4 - etc
I need this this to me multiplied by the quantity column. So if I select Food 1, and select 10 - I need those values multiplied by the quantity volume. I have racked my brain and read probably every article on the web on Vlookup, Macros, etc... I have no idea.
Any thoughts here? THANK you so much in advance.
Bookmarks