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!