在A列中查找多个单元格值，并替换为同一行D列中的变量值

I have searched high and low for something close to this to get me started with the VBA code, but I keep striking out. I'm having a bit of a writers block, and could use any help. I have searched high and low for something clos