Excel look up - simple job

I have a file that a regularly have that has a "Postcode" column in it. I need to look this up on another spread sheet and add what is in the address to the spread sheet.

In the example attached you see the standard "Exported lead file" we need to use the postcode field (column BO) to look up Postcode in file 2 - "PAF" then find the right "Street" value and add this to Address line 2 (BL) of the original spreadsheet.

The job is to build something that just adds the address line 2 on to the initial spreadsheet based on the postcode look up.