+ Reply to Thread
Results 1 to 4 of 4

Partial matching two columns of data?

  1. #1
    Registered User
    Join Date
    01-28-2012
    Location
    Canada
    MS-Off Ver
    Excel 2007
    Posts
    6

    Partial matching two columns of data?

    I'm working with 2 columns of data, the first column will always be the same and the second column will always be different. I'm trying to get the third column to partial match (6 characters) column 2 to the column 1 data. I can get it to work if there's exact matches in column 2 but not for partials

    Any help appreciated, thanks!

    Example excel file attached.
    Attached Files Attached Files

  2. #2
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 2000/3/7/10/13/16/365
    Posts
    52,013

    Re: Partial matching two columns of data?

    See Column C for the answer I think you want?
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  3. #3
    Registered User
    Join Date
    01-28-2012
    Location
    Canada
    MS-Off Ver
    Excel 2007
    Posts
    6

    Re: Partial matching two columns of data?

    It's close, but column D is the ideal answer. In your example it didn't match up the ddd.com to it's correspondent in column A. I'm really stumped with this one and not sure it's possible.

  4. #4
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 2000/3/7/10/13/16/365
    Posts
    52,013

    Re: Partial matching two columns of data?

    Ok, try the attached, hope this helps?

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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