Macro formula to match two columns and Produce result in fourth column.

Hi,
I'm a newbee in Excel programming and macros. I need help creating a Macro formula to match two columns (A & C) and if there's a match, I want it to produce the value that's in column B(right next to column C), into column D. I tried using Vlookup but no luck. So need excel macro code.
Please find sample attached.
Note : All the values will be basically text and not numbers.(in sample you may find some numbers)

Thanks for your help & time.

Awaiting your response back.

Regards,
Roger