Retrieving certain fields from a table using date fields as references based on creterias

Hello,

Please see attached a sample workbook, which would involve a complex formula that I am having lots of trouble with.

The goal here is to extract ID's that either changed programs, remained in the same program, or never returned only after any of the 4 withdrawals listed.

You will notice two desired result sections along with a reference table. One desired result is to extract the program in which the ID has withdrawn. The other is to extract the program when the ID returned and the year next to when the program was returned into.

Thank you in advance!

Note: My actual data set and reference table I has many more columns and rows. What I attached is simply a sample.