Match & Paste the full URL

[Deepak Sharma]

Hello Everyone,
I have uploaded a file, in this file there are two sheets. IN first sheet on domain name is given and in second sheet domain+full url link is given.
What I need to do is...I want to search for domain name from 1st sheet....look into second sheet whole range and if find the domain then paste the full link infront of that particular domain.
The thing is that there are 1 domain on first sheet but full URL is more than 2-3 times, so whenever it searches just pick any domain & paste. Thats it. Pls help.

 

[vletm]

#1: Where is 'second sheet'? ... I could guess ...
#2: Where to paste (... infront of that particular domain ...) ?

 

[Deepak Sharma]

So sorry! Wrongly attached the sheet. Please see the new one.

 

[vletm]

without sample result ...
something like this?