Time and Date of Next Value

[reswan]

First post , hope I've complied with forum rules.

Looking to create a formula to work on values in column E

I want the formula to look at the value in column E and see where the value next appears in either column E or column F. On finding the next occurrence of the value I would like to read the time and date in column A and column B and record it in the row of the initial search value.
The time and date to be recorded should go in column G and column H respectively.

I would like to carry out the same operation on the values in column F. Again looking to see where the next value appears in column E or column F. On finding the next occurrence of the value I would like to read the time and date in column A and column B and this time record in the row of the initial search value but place the time and date in column I and column J respectively.

Attached a workbook with a BEFORE and AFTER worksheet.

thanks for taking a look

[Phuocam]

Try this in cell G2:

=IFERROR(INDEX(A:A,AGGREGATE(15,6,ROW($E3:$F$10)/($E3:$F$10=$E2),1)),"")

[Limor_OP]

There's a mistake in your table? why would line G4 is 13:54 ?

[reswan]

Phuocam - This formula works perfectly

Belinda200 - You are right. I made some unnecessary tweaks, my bad.

Thanks for responding and sorting this for me.