replace code/id values with a name found in a list

Hi, Couldn't think how I could describe this problem in my topic title.

Please see the attachment

I need a macro that will replace the codes in worksheet 1 column C.

To do this I will need to look up the id in Worksheet 2 column B and then replace it using the associated name in Column A of worksheet 2.

All help much appreciated!