If condition met, return all values from column

Hi, thanks for the reply . I did try to post a workbook however as you say the functionality isn't working and the alternative solution wasn't obvious. Thanks for clarifying.

Sample data attached with desired outcome shown in another sheet.