Dynamic External Hyperlink

[LabraLime]

Hello!

I am trying to create an automatic function where as an external website hyperlink is created based on the cell data within my document. I currently have column D setup so that when columns A-C are updated, it generates the value that needs to be replaced in each external hyperlink. I am looking for a way for the bold section of the external hyperlink in Column E to be replaced with the value of Column D.

I have attached a snippet with an example of what I'm trying to achieve.

A

B

C

D

E

12123​

100​

12345​

12123-100-12345

<-I would like to automaticlly generate hyperlink that uses Cell D2 to replace the BOLD number in the example URL below: https://pdm.website.com/download/documents/ 12323-100-00001/EN/lastreleased/viewable/

 

[Toadstool]

Hi LabraLime,

Does this work for you?

LabraLime.xlsx
	A	B	C	D	E
1	A	B	C	D	E
2	12123	100	12345	12123-100-12345	https://pdm.website.com/download/documents/12123-100-12345/EN/lastreleased/viewable/
3	12345	222	54321	12345-222-54321	https://pdm.website.com/download/documents/12345-222-54321/EN/lastreleased/viewable/
4	22222	333	44444	22222-333-44444	https://pdm.website.com/download/documents/22222-333-44444/EN/lastreleased/viewable/
5	99999	999	99999	99999-999-99999	https://pdm.website.com/download/documents/99999-999-99999/EN/lastreleased/viewable/
6	22334	223	33233	22334-223-33233	https://pdm.website.com/download/documents/22334-223-33233/EN/lastreleased/viewable/
7
Sheet1

Cell Formulas
Range	Formula
D2:D6	D2	=A2&"-"&B2&"-"&C2
E2:E6	E2	=HYPERLINK("https://pdm.website.com/download/documents/"&D2&"/EN/lastreleased/viewable/")

 

[LabraLime]

Hi LabraLime,

Does this work for you?

LabraLime.xlsx
	A	B	C	D	E
1	A	B	C	D	E
2	12123	100	12345	12123-100-12345	https://pdm.website.com/download/documents/12123-100-12345/EN/lastreleased/viewable/
3	12345	222	54321	12345-222-54321	https://pdm.website.com/download/documents/12345-222-54321/EN/lastreleased/viewable/
4	22222	333	44444	22222-333-44444	https://pdm.website.com/download/documents/22222-333-44444/EN/lastreleased/viewable/
5	99999	999	99999	99999-999-99999	https://pdm.website.com/download/documents/99999-999-99999/EN/lastreleased/viewable/
6	22334	223	33233	22334-223-33233	https://pdm.website.com/download/documents/22334-223-33233/EN/lastreleased/viewable/
7
Sheet1

Cell Formulas
Range	Formula
D2:D6	D2	=A2&"-"&B2&"-"&C2
E2:E6	E2	=HYPERLINK("https://pdm.website.com/download/documents/"&D2&"/EN/lastreleased/viewable/")

Yes this is perfect! Thank you so much for your help!

 

[Toadstool]

Yes this is perfect! Thank you so much for your help!

You're welcome!
Thanks for the feedback.