Matching 2 Tables and Pasting it on another Column

[TeckTeck]

Hi all, i am new to Excel and would like to know what is the code for VBA for this to happen.

I would need to match the reference list to master list,

Condition 1: IF column A matches Column C then paste Column C on Column E
Condition 2: IF column B matches 50% or 60% of Column D (text) then paste column C on Column E

Please advice on how to do this. Appreciated very much

 

[Legacy 143009]

Why not to use formula? E3:

=IF($A3=$C3,$C3,IF("*"&$B3&"*"=$D3,$D3,"NO MATCH"))

It is hard to specify something like %50 or %60. Please, check if this works.
Maybe:

=IF($A3=$C3,$C3,IF(AND("*"&$B3&"*"=$D3,LEN($B3)/LEN($D3>0.50),$D3,"NO MATCH"))