[Solved] Data Validity list with names for choice

[morphingstar]

the menu of function data VALIDITY shows exactly the list referred to, range e.g. a1:a10.
If the list consists of URLs the menu shows http:____________, hard to find which URL applies.
Therefore as in URL in Writer, 2 or 3 fields are required:
1) the actual URL
2) A name for it

GOAL: The validity menu should show the name for, not the actual URL. It uses cell range or list, as selected while defining it.

The validity menu cell is b1,
The actual hyperlink click cell is b2. containing
=hyperlink(validity:cell)
or
=hyperlink(b:1)

how use names for this application?

I shall enjoy a HYPER-ANSWER

[RusselB]

Have you tried using the second parameter of the hyperlink function to point reference the actual selection?

GOAL: The validity menu should show the name for, not the actual URL. It uses cell range or list, as selected while defining it.

How is the validity menu supposed to know that you want the name, rather than the URL displayed?

[morphingstar]

How is the validity menu supposed to know that you want the name, rather than the URL displayed?

1) by design
2) by workaround, which refers to the subject of this thread.
3) by something I did not find out / have not thought of
Happy?

[RusselB]

1) by design
2) by workaround, which refers to the subject of this thread.

Have you tried using the second parameter of the hyperlink function to point reference the actual selection?

[morphingstar]

2nd parameter
1 choice shown in Validity:
LX4 Upgrade keine Verbindung 20190813.jpg NAME="NameText"
Path, file, desired alternative Name
C:\Users\ALL\Pictures\_printscreen\LX4 Upgrade keine Verbindung 20190813.jpg NAME="NameText"
from Calc HELP
"http://www.example.com/" NAME="Nametext"

Windows can not find.

the HELP example shows a html version, this URL does not seem to operate in Calc.
Validity does not split path+file ¦ Name. It can only handle 1 cell at one time.

Setting Validity cell to right adjust helps nothing. Use of slide bar required. Clumsy.

[Villeroy]

=HYPERLINK(INDEX($A$1:$A$4;MATCH(D1;$B$1:$B$4;0));D1)
where A1:A4 is the column of URLs, B1:B4 is the column of labels and D1 is the validated list linked to the column of labels. The formula returns a clickable hyperlink in some other cell.

=HYPERLINK(INDEX(URLs ; MATCH(validated_cell ; labels ; 0)) ; validated_cell)

[morphingstar]

Solved using the method in the attached file