Postcode check and return of value in column title and cell adjacent to postcode

Hi all

I have a workbook which contains postcodes that lay within a radius of sites. Line A contains the column titles and each cell below contains the postcode and to the right of that cell the mileage from the site. I need to create either a macro or formula driven request in Sheet 2 where a postcode can be entered and if it exists within Sheet1 the output is the column name and the mileage. I really do not know where to start on this one!

Apologies that it is a blank canvas to work from - this is only part of the workbook as one site has 92k postcodes associated to it!

Many thanks

BigTP