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
Bookmarks