Results 1 to 4 of 4

Trying to match up 2 columns of data on a partial match

Threaded View

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

    Trying to match up 2 columns of data on a partial match

    I'm an excel noob, been googling for hours... surrendering to this forum.

    Column A (will always be the same list)

    aaaa.com
    bbbb.com
    cccc.com
    dddd.com

    Column B (different everytime)

    cccc.com/excel-help
    aaaa.com/i-use-excel-2007
    dddd.com/sub-url

    Column C (my ideal result)

    aaaa.com/i-use-excel-2007
    (left blank cause no match related to bbbb.com)
    cccc.com/excel-help
    dddd.com/sub-url



    Tried uploading a sample spreadsheet but I got some kind of error.

    Any help / advice greatly appreciated!

    Thanks!
    Last edited by tmedia; 01-28-2012 at 04:00 AM.

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