+ Reply to Thread
Results 1 to 1 of 1

Text Matching based on partial text

  1. #1
    Registered User
    Join Date
    12-10-2009
    Location
    New City, NY
    MS-Off Ver
    Excel 2003
    Posts
    6

    Text Matching based on partial text

    Hello, I'm trying to merge records from two separate datasets.
    • There is no hard match key that would allow for an easy vlookup.
    • However, the records in each dataset include a company name field.
    • When the company names are identical, I can use them in a vlookup.

    But sometimes the company names differ by only a few letters:
    Example:
    Record from dataset 1: Xerox Corporation
    Record from dataset 2: Xerox Corp

    So it's obvious to a person that these two records belong together, but vlookup would not recognize the union.

    My request: is there a way to devise a macro or formula that will help establish a reliable match between records from the two datasets, based on a close (but not 100%) match between the company name fields.

    Since I'm not a VBA expert, could you please include some context to the solution if this calls for a macro....

    I've attached an illustrative sample workbook.

    Thanks very much.
    - Leo


    Please note there was a related post earlier in 2011, but the final answer was unclear to me:
    http://www.excelforum.com/excel-prog...t-vlookup.html
    Attached Files Attached Files
    Last edited by LKluger; 07-20-2011 at 04:24 PM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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