Look up values in from one table and fill in a column on another table with corresponding

I can't remember how to do this - help appreciated.

I have codes that correspond to text in one table and I need to put the text that matches these codes into columns in another table.

Example attached.

In other words:

Identify match the codes in column C on the first tab with column C in the second tab
Then draw across the data from columns A and B in the second tab into columns D and E in the first tab



Can anyone help?