Can Not “Launch” Friendly Named Hyperlink.

[Scoopitup]

Problem: A2 Will not “Launch” B2 which contains a “Friendly Named Web Address Hyperlink”. I need B2 to contain a Friendly Name of my choosing.

Formula in A2: =HYPERLINK(B2,"Launch")

Formula in B2: =HYPERLINK("https://www.google.com/","Google")

 

[zweifuss]

Mappe2
	A	B	C
1	Launch	Google	"https://www.google.com
Tabelle1

Cell Formulas
Range	Formula
A1	A1	=HYPERLINK(C1,"Launch")
B1	B1	=HYPERLINK(C1,"Google")

 

[Scoopitup]

Mappe2
	A	B	C
1	Launch	Google	"https://www.google.com
Tabelle1

Cell Formulas
Range	Formula
A1	A1	=HYPERLINK(C1,"Launch")
B1	B1	=HYPERLINK(C1,"Google")

Thanks – That almost works for what I’m trying to build. I should have explained it better. My bad. After deleting header row 1 it will look like this below. There will be a drop-down menu in column C referencing or pointing to validated data in column B which will be a hidden column. I will then use the drop down to select a site, click launch, and go to the website.

Thanks.

 

[Scoopitup]

Thanks – That almost works for what I’m trying to build. I should have explained it better. My bad. After deleting header row 1 it will look like this below. There will be a drop-down menu in column C referencing or pointing to validated data in column B which will be a hidden column. I will then use the drop down to select a site, click launch, and go to the website.
View attachment 47087
View attachment 47088
Thanks.

Again the problem is with Friendly name links in column B clicking Launch go nowhere.