Forum Discussion
How to get the link to show the text in referenced cell
Hi
You can create a DYNAMIC Hyperlink that changes based on cell contents.
To do this,
You need to create a "Hyperlink Function"
The first argument of the Hyperlink Function is a cell reference to a destination.
The second argument of the "Hyperlink Function" is a User Friendly Name
I am attaching here with a link to one of my tutorials in which I explain this function in details (you can jump to minute 9:00 of the Tutorial)
https://www.youtube.com/watch?v=FeKgWSD8IWc
hope that helps
Nabil Mourad
nabilmourad Thanks for the help! Unfortunately I am still having trouble figuring this out... I dont understand what each component of that structure does... Could you please break down each part for me? As I am sure you have noticed, I am not very knowledgeable in Excel.... So from my understanding, my hyperlink should look something like this: '=HYPERLINK("#"'&A2&"'!A1",A2)
what is the # sign for?
Thanks!
Hi
It's obvious you have a problem with the position of the Single quotation and the double quotations.
Also tell me what do you have in Cell A1, Cell A2 and in which cell you write the formula?
You need to follow this pattern.
If I had a file I would do it for you (or look at my tutorial for this part)
Nabil Mourad
nabilmourad I posted a basic excel file of what I am essentially trying to do. So on my index page Column B is where I want to attach the link (with friendly name) to cell A1 from every page except the index (which contains a room name in that cell).