So I am looking to create a function that searches for a unique ID code in one column, and returns a corresponding time stamp from another column. However, there are multiple time stamps attached to each unique ID code. I want to only return the time stamp that is immediately following a specified time.

For example, for Unique ID “9f45Q3”, there are 4 time stamps attached to it:

• 11:00
• 11:15
• 11:40
• 11:55

I need to find a way to tell Excel to return the time stamp for “9f45Q3” that most immediately followed 11:30. ( just an arbitrary time for the sake of explaining) In this case, I would want Excel to return 11:40, because it most immediately follows my specified time.

Any help would be much appreciated. Thank you!