+ Reply to Thread
Results 1 to 3 of 3

Subtraction, Dynamic tables, Dropdown, Index

  1. #1
    Registered User
    Join Date
    01-03-2014
    Location
    United States
    MS-Off Ver
    Excel 2010
    Posts
    2

    Subtraction, Dynamic tables, Dropdown, Index

    Ok im trying to take the result from a dropdown that used Index function then match that result with another dynamic table
    Then take the time value next to that result and subtract it from another time not in a dynamic table.

    Example
    SHEET 2
    COLUMN B is a dropdown that has its options populated based on dropdown on COLUMN A. Using Index function
    =INDEX(SYSTEM_HOLD,,MATCH(Node,Node_List,0))

    COLUMN H is a time field that is variable


    SHEET 1
    COLUMN G,H are table system_time
    G named system_time_node
    H named system_time_start



    I need COLUMN K in SHEET 2 to display final output from
    the time from SHEET 2 COLUMN H subtracted by the time in system_time_start based the value in same row COLUMN G that matches value chosen from dropdown list in COLUMN B

  2. #2
    Forum Contributor noboffinme's Avatar
    Join Date
    08-29-2013
    Location
    Melbourne, Australia
    MS-Off Ver
    Excel 2003/7/10/13/16/19
    Posts
    1,067

    Re: Subtraction, Dynamic tables, Dropdown, Index

    Hi cashflo,

    Your issue might be easier to understand if you post the file you're using.

    Thanks
    Remember you are unique, like everyone else

  3. #3
    Registered User
    Join Date
    01-03-2014
    Location
    United States
    MS-Off Ver
    Excel 2010
    Posts
    2

    Re: Subtraction, Dynamic tables, Dropdown, Index

    I can't load file because of Company data that is restricted.
    I can try to create a copy that just has fields needed and with test data. That may take a day or so.

+ 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: 0
    Last Post: 01-29-2014, 02:58 PM
  2. Dynamic Stock subtraction
    By daan_vb in forum Excel General
    Replies: 2
    Last Post: 11-26-2013, 06:11 AM
  3. [SOLVED] Dynamic Subtraction
    By JKK123 in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 02-03-2013, 06:53 PM
  4. Dynamic Dropdown
    By Chemo in forum Excel General
    Replies: 1
    Last Post: 07-28-2011, 07:08 PM
  5. dropdown menu for tables
    By käböu in forum Excel General
    Replies: 7
    Last Post: 04-19-2010, 06:00 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