Find next instance of name/number in column and return date if matches criteria

[jaxo]

Hi, I need a formula to be entered into the Date Out column of example sheet, correct date is posted to the right of table as example. Formula should return a date next to "Opening Stock" or "Move +". It should read the next instance of Paddock number and if the process is Opening Stock" or "Move +, record the date from that row in the Date Out column next to the above "Opening Stock" or "Move +" Would appreciate solutions.

LSR Forrester 2023b.xlsx
	E
14
Input

 

[Peter_SSs]

If the follow-up questions are very closely related to the original one here you can continue in this thread. Otherwise you would be better to start a new thread (you can put a link to this one in it if you think that would help) with new sample data and expected results as more potential helpers will look at the new thread as opposed to one that already has quite a few replies.

 

[jaxo]

Thanks Peter. I appreciate the solution and advice. Well done on the cricket .

 

[Peter_SSs]

You're welcome. Thanks for the follow-up.