How to find if one column (b) includes value of cell in column c and if so, pull column d

[JoshuaElphee]

I have a very large workbook where I need to add the following logic:

"If value for a cell in column C exists in column B as well (most cells blank in this column), pull the date value in column D for that cell and add as a new column for all rows with an equivalent in column c".  

The below example explains better - in essence the project at the top level will not have a program number.  However program being blank alone does not mean that is the date to utilize.

My next step will be to remove all rows where the output in column E is prior to 1/1/2024, where column E shows a date since 1/1/2024 they are to remain.

Input example

ID	Project	Program	Date	(to be included in output)
1	ALPHAB		12/2/2023
2	BravoC	indigo	1/4/2024
3	CharlieD	ALPHAB	2/4/2024
4	DeltaF		1/16/2024

Desired output

ID	Project	Program	Date	NEW DATE
1	ALPHAB		12/2/2023	=column D
2	BravoC	indigo	1/4/2024	=column D
3	CharlieD	ALPHAB	2/4/2024	12/2/2023
4	DeltaF		1/16/2024	=column D

[Qiu]

@JoshuaElphee 
I dont quite understand the meaning of "=column D" so I only populated the part of matching. and hope this would help.