Results 1 to 18 of 18

Drop down list to auto-populate fields and multiplied by another field

Threaded View

  1. #1
    Registered User
    Join Date
    02-24-2012
    Location
    London, England
    MS-Off Ver
    Excel 2010
    Posts
    9

    Drop down list to auto-populate fields and multiplied by another field

    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:
    1. Food 1 - This should place a "1" under Pizza in the list below
    2. Food 2 - This should place a "1" under Pizza & Tacos in the list below
    3. Food 3 - etc
    4. 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.
    Last edited by semajarab; 02-24-2012 at 03:55 PM. Reason: Solved

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1