looking at two sheets & show matching records

[PW6780]

Hello,

I have attached my spreadsheet.

In sheet 1, i have a list of fictitious schools with addresses, in sheet 2, i have a list of fictitious students with addresses

What i require is a formula that sits in column F of sheet 2, that looks at the students 'postcode' then searches for the same postcode in the schools list in sheet 1.

If any of the postcodes match then the name of the school, would be required to show in the column F, for that student.

In my attached spreadsheet, the only match is 'Ben' and 'School 8' so whats required is a formula that would return 'School 8' to the cell F7 on sheet 2.

Many Thanks in advance.