Hyperlinks & Formulas
Hello,
I had a hyperlink living in a sheet and did a vlookup to another sheet to pull the hyperlink in which worked. However, once I went to the original sheet where the hyperlink was and changed the display name of the hyperlink, it worked on that sheet, but the vlookup on the other sheet does not provide the link only the display name and nothing happens when you click the display name.
Can you advise how I can get the display name to carry over with the hyperlink?
Thank you!
Answers
-
Unfortunately it does not work that way. Even with direct cell references in the same sheet, the only way to get a working hyperlink to pull is to leave it as the URL. If you change the display to some specific text, then only the text will pull.
Please do take a moment to Submit a Product Enhancement Request when you are able as it would be great if we could pull hyperlinks with displayed text that is not the URL.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.9K Get Help
- 441 Global Discussions
- 139 Industry Talk
- 471 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 68 Community Job Board
- 496 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!