Ive added a sample of the workbook with all other info removed.
You can see there are 3 sheets. Sheet 1 is for users to enter information, and column B in sheet 1 is where I would like the ward area to auto fill when the postcode is entered into column A. The postcodes to check are on sheet 2, and then the total I would like to populate are on sheet 3.
Hope it makes sense, I have gone spreadsheet blind