I have an issue with a spreadsheet where I am trying to convert lists of postcodes into a set building e.g. if your postcode is 123 ABC then your nearest community centre is Centre name 1.
I have a list of the postcode address for my members plus the addresses of the various community centre catchment area but am unsure how to do this
Could you please upload a sample EXCEL file WITH sample data, macro, formula , conditional formatting etc on some shared site like https://authentification.site , http://docs.google.com,http://wikisend.com/ , http://www.editgrid.com etc and post back here the link to allow better understanding of how it is now and how you foresee. Based on the sample book, could you re-explain your problem too
