Results 1 to 15 of 15

Matching two lists of postcodes

Threaded View

  1. #1
    Registered User
    Join Date
    07-25-2023
    Location
    England
    MS-Off Ver
    office 365
    Posts
    6

    Matching two lists of postcodes

    Hi,

    I have a list of postcodes that relate to actual addresses (list 1) and another list of postcodes that are broken down by which areas of the city they belong to (list 2)

    I would like to be able to use a function to match/show which areas of the city postcodes from list 1 are in by comparing against list 2.

    Can anyone help me with this?

    I have attached a small example to show the type of data I have.

    Thanks.
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Index matching on postcodes - but only a certain part of a postcode
    By blackrosepetals9169 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 07-20-2018, 09:40 AM
  2. [SOLVED] Matching of Lists
    By y0shi in forum Excel Formulas & Functions
    Replies: 14
    Last Post: 04-16-2015, 06:31 AM
  3. Matching between two lists
    By Climaxgp in forum Excel General
    Replies: 3
    Last Post: 02-25-2010, 09:44 AM
  4. Matching two lists?
    By NPgs1uk in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-02-2007, 06:54 AM
  5. Matching 2 lists
    By pberdann in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 08-10-2006, 12:20 PM
  6. Matching two lists.
    By Jwhite in forum Excel General
    Replies: 1
    Last Post: 03-16-2006, 07:20 PM
  7. matching lists
    By dakotasteve in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-04-2005, 04:56 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1