henryvii99
New Member
- Joined
- Apr 22, 2011
- Messages
- 32
Hello,
I would like to lookup a value in specific column after condition is met
In my case, I want to report the time on row 1 after the time specified in table 2
Here's my example data:
<tbody>
</tbody>
Here's the control table, the specified time for table lookup is different for each column
<tbody>
</tbody>
The expected values are:
A: N/A (as it never fall below min. price)
B: 10:37
C: 10:37 (not 10:29 as it does not reach specific time yet)
D: 10:39
I think I can use index to find my values, but the problem is I will only look for values after the specific time
Any help is much appreciated, many thanks for your help!
I would like to lookup a value in specific column after condition is met
In my case, I want to report the time on row 1 after the time specified in table 2
Here's my example data:
Time | Price1 | Price2 |
18/5/2018 10:25 | 405 | 10 |
18/5/2018 10:27 | 400 | 20 |
18/5/2018 10:29 | 395 | 30 |
18/5/2018 10:31 | 390 | 40 |
18/5/2018 10:33 | 400 | 50 |
18/5/2018 10:35 | 410 | 45 |
18/5/2018 10:37 | 420 | 35 |
18/5/2018 10:39 | 430 | 65 |
<tbody>
</tbody>
Here's the control table, the specified time for table lookup is different for each column
Price 1 | Price 2 | |
Start to count | 10:27 | 10:33 |
Price at counting | 400 | 50 |
Min. price | 380 | 40 |
Max. price | 420 | 60 |
Time when price below min. | A | C |
Time when price reach max. | B | D |
<tbody>
</tbody>
The expected values are:
A: N/A (as it never fall below min. price)
B: 10:37
C: 10:37 (not 10:29 as it does not reach specific time yet)
D: 10:39
I think I can use index to find my values, but the problem is I will only look for values after the specific time
Any help is much appreciated, many thanks for your help!