Automatically applying hyperlinks from one cell to another

[Piripero]

I have a workbook that has a column which contains the titles of different documents which are published to a website (B4:B6). Another column contains the URLs for those documents (C4:C6).

[TABLE="class: grid, width: 700"]
<tbody>[TR]
[TD]Document Title[/TD]
[TD]External Link[/TD]
[/TR]
[TR]
[TD]How to Eat Worms[/TD]
[TD]www.fakewebsite.com/how-to-eat-worms[/TD]
[/TR]
[TR]
[TD]How to Dig a Hole[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]How to Avoid Looking Directly at the Sun[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]


I have a user who is used to manually inserting a hyperlink into the cell which contains the title, so that the title cell points to the URL. He wants the title cells to be hyperlinked, understands the need to have the hyperlink in its own cell for reference purposes, but doesn't want to re-type or copy-paste the URL. How do I setup the URL cells (C4:C6) to check the title cells for embedded hyperlinks, and if it finds one, to replicate it in the appropriate URL cell?

Alternatively, how do I setup the title cells to check the URL cells for text, and if it finds some, to automatically apply that text as a hyperlink in the appropriate title cell?

And worst of all, how do I do this without using VBA/macros?

Helper columns are totally fine if necessary.

 

[Piripero]

I should note: the External Link is not strictly derived from the title. A more accurate example URL would have been www.fakewebsite.com/how-to-eat-worms-34528, with no way of predicting ahead of time what the number will be.