Try this in cell F3 and copy down as needed.

=IF(E3="Yes",VLOOKUP(D3,'DO NOT DELETE'!$A$2:$B$5,2,FALSE),0)

Does that do what you need?