Multiple Row Conditional Search Formula

All,

Looking for help on the development of a formula that will search for the next string that matches a condition, where the date in the cell directly beneath that cell is greater than another cell reference. I've attached an example excel sheet to give you an idea of what i'm talking about.

Any help would be appreciated. Thanks in advance.