I have a list of beginning parts of UK post codes that (ie N1, EC1 etc) that I need to match up with full post codes (N78TZ, EC14BY etc) but i need the macro to identify just the beginning parts , which are sometimes 2 or 3 digits long....how can this be achieved?
sample sheet included. See colomn A has the full post code, it needs to match that to the list in the other sheet (called PC) and in Col B return either A or B (or Other if the post code doesnt feature)
Bookmarks