Return matching string in array if cell contains string contained in the array

[AaronsZ]

Hi everyone,

I have a spreadsheet of web traffic data that I am trying to clean up.

In column A, I have a bunch of different variants of URLs (google.com, google.co, google.com/search, yahoo.com, http://yahoo.com, ....).

In column C, I have a bunch of "main" URL groups (google, yahoo, bing,...)

In column B, I'm looking for a formula to display the appropriate "main" URL string from column C (if applicable), otherwise display the original string contained in column A.

Any ideas? I was able to create a workaround by inserting a IF(ISERR(FIND()) for each "main" URL value but that quickly made the formula much too long and memory intensive. I would really appreciate any help!

Thank you!

[bebo021999]

May be in B1:

Please Login or Register  to view this content.

Confirmed with Ctrl-shift-enter

[FDibbins]

Hi and welcome to the forum

It would make it easier if we could see what you have, but try this. you can do a search using wild cards....=vlookup("google"&"*",data_range,1,false)

[AaronsZ]

May be in B1:

Please Login or Register  to view this content.

Confirmed with Ctrl-shift-enter

This works great, bebo! I just changed the "" to A1 to display the original string. Thank you!