Hi
This is just an alternative solution
=(E3="Yes")*INDEX('DO NOT DELETE'!B:B,MATCH(Sheet3!D3,'DO NOT DELETE'!A:A,0))