Index Match – retrieve a value between 2 dates across different rows
Hi all,
I am hoping someone can help me! It’s a very tricky one! In the table below, I need a formula that tells me that for APP-102760 the value was 3 on the 30th January. The edit date shows the date the value changed from ‘Old Value’ to ‘New Value’. As the 30th January is between Edit Dates 11/01/2023 and 21/02/2023, I can see that the value was 3.
Application: Application NameField / EventOld ValueNew ValueEdit DateAPP-102760Probability of Arrival 205/12/2022APP-102760Probability of Arrival2311/01/2023APP-102760Probability of Arrival3421/02/2023APP-102760Probability of Arrival4522/05/2023
Hi all, I am hoping someone can help me! It’s a very tricky one! In the table below, I need a formula that tells me that for APP-102760 the value was 3 on the 30th January. The edit date shows the date the value changed from ‘Old Value’ to ‘New Value’. As the 30th January is between Edit Dates 11/01/2023 and 21/02/2023, I can see that the value was 3. Application: Application NameField / EventOld ValueNew ValueEdit DateAPP-102760Probability of Arrival 205/12/2022APP-102760Probability of Arrival2311/01/2023APP-102760Probability of Arrival3421/02/2023APP-102760Probability of Arrival4522/05/2023 Read More
