+ Reply to Thread
Results 1 to 5 of 5

Multipy a cell depending on value in drop down list

  1. #1
    Registered User
    Join Date
    12-30-2009
    Location
    Belgium
    MS-Off Ver
    Excel 2007
    Posts
    10

    Multipy a cell depending on value in drop down list

    Hi,

    I'm making an semi-automatic price calculation sheet for my production company.
    In my sheet, I have a table with the names of the different machines in my factory and the hour rates (euro/hour) in a column next to it.

    In column D, I have a drop down list from which I can choose the names of the machines listed in the table.
    In column E, I specify the hours that this specific machine will be used.

    Now, in column F, I want to calculate the price, i.e multiply the hours specified in column E with the hour rate of the machine specified in the table deppending on the value/name chosen in column D.

    How can I do this?

    Regards,
    Steven

  2. #2
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2403 Win 11 Home 64 Bit
    Posts
    23,810

    Re: Multipy a cell depending on value in drop down list

    Without seeing a copy of your file, it is difficult to give you the exact formula. If you wish to load a sample file, that would be helpful. Lacking that, I would offer up this suggestion. In Column F, I would create a formula that multiplies column E times a vlookup formula. Your vlookup would look something like this

    vlookup(ColumnD,Table Holding Hourly Rates, Column in Table with Rate, False). If you need further understanding of vlookup, then click on this link

    http://www.techonthenet.com/excel/formulas/vlookup.php
    Alan עַם יִשְׂרָאֵל חַי


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form

  3. #3
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,917

    Re: Multipy a cell depending on value in drop down list

    Assuming you have a 2nd table that contains the rate/hour of the different machines, you would use a vlookup() to find the value, based on thte machine selected from teh DD, then * that by the hours worked
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  4. #4
    Registered User
    Join Date
    12-30-2009
    Location
    Belgium
    MS-Off Ver
    Excel 2007
    Posts
    10

    Re: Multipy a cell depending on value in drop down list

    Hi guys,

    VLOOKUP() did the job!

    THanks!!

  5. #5
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2403 Win 11 Home 64 Bit
    Posts
    23,810

    Re: Multipy a cell depending on value in drop down list

    If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 1
    Last Post: 06-22-2014, 02:39 AM
  2. 2 Drop down lists depending on 1 other drop down list.
    By giomath in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 06-14-2013, 10:48 AM
  3. List all items depending on Drop-list Value
    By ioloroberts in forum Excel General
    Replies: 1
    Last Post: 03-01-2013, 07:43 AM
  4. Replies: 4
    Last Post: 06-30-2012, 11:05 AM
  5. Moving row to different sheet depending on cell value from drop down list
    By antagius in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-06-2012, 06:06 AM

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