Return a value e the action was executed after x date and before x date +1

[Pico_01]

Good Afternoon,

My question is related to an action that has the following requirements, once executed we have 2 results possible, Pass/fail. If is fail, that triggers another action that needs to occur after 24h from the first action.

In my excel i have the column of dates, and i have in a separate table all the actions that failed the first execution.

in this second table i am trying to write a formula to confirm and return the value (date) of execution of the trigger action, in order to control and see if all those actions are being done correctly.

The formula that i am trying to use is: IF(A1:A16<E9;IF(A1:A16>F9;VLOOKUP(G9;B:C;2;FALSE);""))

But some how the formula is not working

Thanking in advance for your support,

[lexusap]

Hi,

do you have sample workbook for us to see? and also write down the result you wanted too.

Cheers
Albert

[lexusap]

Hi,

It seems like you are missing the statement if A1:A16<E9 equal to true

Please Login or Register  to view this content.

Would this help?





Please don't forget to thank those who helped by clicking on Add Reputation * and please mark thread as "Solved" if your issue has been resolved. (Selecting Thread Tools-> Mark thread as Solved).

[Pico_01]

Thank you for your support, attached i placed an example with the expected result and the calculation that i am using.

In this calculation what i am finding a challenge, is for the formula to identify the date that i want from the list, and then execute the Vlookup.

Please give you your thoughts on how to crack this,

Once again thank you for the support,

Regards

[bebo021999]

Maybe:

=(LOOKUP(2,1/($E$2:$E$17=L4+1),$C$2:$C$17)=M4)*L4+1

[Pico_01]

Thank you for the input,
the formula worked,
Can you please clarify the (2;1/ and the *L4+1

thanking in advance,