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

**tmedia** · 01-28-2012, 02:44 AM

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!

**grizzly6969** · 01-28-2012, 03:16 AM

to uplaod a sample work book click Go Advanced then click on Paper clip click on Add Files click Select Files
click on the sample file you wish to upload then click Upload Files then done Done

you may have to click on paper clip 2 x to open

**tmedia** · 01-28-2012, 04:00 AM

Originally Posted by grizzly6969

to uplaod a sample work book click Go Advanced then click on Paper clip click on Add Files click Select Files
click on the sample file you wish to upload then click Upload Files then done Done

you may have to click on paper clip 2 x to open

Yea I figured that much out but it failed on the upload.