Prevent duplicate entry to a column with refer to another columns

Hi all,

I need your help on VBA for preventing duplicate entry. The requirement as attached file.

Hope I can get the support soon.

Thanks for your view and support very much.