Thequestion
New Member
- Joined
- Jan 27, 2016
- Messages
- 18
Dear reader, I'm having a problem with a nested if statement. Based on the dates in my first tab, I search in the range of dates in my second tab, if true, then I do the same thing with the times in the same formula, if true I want the corresponding value of my second tab, otherwise a blank ("") but each cell should consist of a value with a correct formula.
This worked: =
<tbody>
</tbody>
<tbody>
</tbody>
Second tab
<tbody>
</tbody>I also tried to solve this problem with match without success.
Hopefully someone can help me so I can help others as well in the future
This worked: =
IF(A2=Spot!A3,IF(B2=Spot!L1,Spot!L3,""),"") A2 & SpotA3 being 17/02/2016 B2 and L1 being 11:00 L3 being the corresponding correct value However, with the above formula I need to find all corresponding values myself 1 by 1. This formula didn't work: =IF(A2=Spot!A:A,IF(Tab1!B2=Spot!1:1,Spot!B2:Y415,""),"") Spot!B2:Y415: being the range in which the correct value is |
<tbody>
</tbody>
First tab Time | Stamp |
17/02/2016 | 11:00:00 |
<tbody>
</tbody>
Second tab
Time interval | 01:00:00 | 02:00:00 |
18/02/2016 | 20.74 | 20.57 |
17/02/2016 | 18.97 | 18.86 |
<tbody>
</tbody>
Hopefully someone can help me so I can help others as well in the future