Need to Extrapolate Data in Column B if Cells Column A Contains Same String

[markadoi84]

Seems like the title is a poor explanation! So allow me to be more specific.

I have a long list of URLs, which are in Column A. Then I have contact details for the website in Column B.

Some of the URLs are from the same website. E.g. example.com/page-one and example.com/page-two.

In which case, I extracted the main domain (example.com) and entered the contact details into Column B. However, this means that only one of the rows has the contact details in Column B.

What I'd like to do automatically fill in the contact details in Column B if the URL is from the same website is the same in Column A. I have a list of maybe 200 domains, with anywhere between 1 and 25 URLs for each. So I don't want to do this by copying and pasting for each domain. Rather, I'm sure there's a clever formula that will automate this for me?

Thanks for taking the time to read and I hope one of you will be able to help!

Mark

[hemesh]

Can you post and sample book
go to advanced use paper clip icon

[azumi]

Maybe something like this?

Please check the file attach....

Azumi

[SDCh]

see the attachment