Hi everyone
I've tried to complete this task with my limited knowledge and I've hit a brick wall.
The attached document contains three sheets. Here's what I'm trying (and failing) to do:
When entering a postcode (zip code for those outside the UK) in to Column C of the 'Participants' sheet, I want it to search the sheet titled 'Combined postcodes', Column A, and autofill in to column E in the 'Participants' sheet the ward as listed in Column C the 'Combined postcodes' sheet.
Once this is done, I want to be able to count how often the Ward appears in the sheet 'Participants' and show it against the ward name in the sheet 'Ward totals'.
To complicate this a little further, if a postcode entered in the 'Participants' sheet does not correspond with any postcodes in 'Combined postcodes' sheet, I want it to autofill as 'Outside area' and this would be counted against the Outside area tally on the 'Ward totals' sheet.
I realise that this seems like a big task (well it does to me) but I'm hoping that for some of you very experienced Excel users this will be a walk in the park!
I will really appreciate your help on this. I hope someone can do me a huge favour!
Many thanks in advance
Ian
Bookmarks