+ Reply to Thread
Results 1 to 3 of 3

Address Matching - VLOOKUP?

  1. #1
    Registered User
    Join Date
    09-22-2010
    Location
    nottingham, England
    MS-Off Ver
    2010
    Posts
    1

    Question Address Matching - VLOOKUP?

    Hello

    I am attempting to carry out some address matching and wondered if someone could help.

    I have one list of addresses which just contain the house number and street name....and I need to match this against a longer list of addresses which contain the full address (inc. town, county, zip code)

    Column A Column B
    full address id
    Row 1 20 High Street TownName Nottinghamshire NG4 2AA
    Row 2 40 Main Road TownName Nottinghamshire NG4 2AA
    Row 3 42 High Street Street TownName Nottinghamshire NG4 2AA
    Row 4 45 Main Road TownName Nottinghamshire NG4 2AA

    So I need to take the address in sheet 1 cell A1 and compare it against a range in a separate sheet - Sheet2!$A$1:$A$4

    Column A
    short address
    Row 1 20 HIGH STREET
    Row 2 22 MAIN ROAD
    Row 3 45 MAIN ROAD
    Row 4 22 HIGH STREET


    and if it matches then return a GH in Column B on the first sheet

    Any help would save me a lot of time manually matching

  2. #2
    Forum Guru Bo_Ry's Avatar
    Join Date
    09-10-2018
    Location
    Thailand
    MS-Off Ver
    MS 365
    Posts
    7,211

    Re: Address Matching - VLOOKUP?

    Please try at Sheet2 B2

    =VLOOKUP(A1&"*",Sheet1!A1:$B$4,2,)

  3. #3
    Forum Expert
    Join Date
    10-10-2016
    Location
    Sheffield
    MS-Off Ver
    365 and rarely 2016
    Posts
    3,212

    Re: Address Matching - VLOOKUP?

    it would be better if you attached a workbook
    =IF(ISNUMBER(MATCH(a2&"*",Sheet1!A:A,0)),"GH","")

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Matching information three ways (NAME,amount,address)
    By Jonces in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 07-30-2018, 07:31 AM
  2. Email Address Matching in Two Worksheets
    By bisnamatchissues in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 12-10-2015, 11:58 AM
  3. Matching and highlighting addresses in a address book
    By GioTrevor in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 04-14-2014, 03:22 PM
  4. Matching Address
    By aanaduta in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 04-09-2014, 01:34 AM
  5. Validating address with matching numbers
    By Armored Wing in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-23-2011, 03:58 AM
  6. Matching Address Columns
    By pw034 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 06-27-2007, 08:34 AM
  7. Cell Address Matching
    By khalid in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 12-27-2005, 10:20 AM

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