Forum Discussion
How to get the link to show the text in referenced cell
So I have an index that links to other sheets. But it will name the link '1'. I am not sure what i need to do, so that the hyperlink simply copies the text in a specific cell, which in this case will...
Hi
I just looked at your sample and here is the function
Copy and Paste in Cell B1
assuming that you have in Column A starting from A2:
0001,0002,0003...
=HYPERLINK("#'"&A2&"'!A1",A2)
Hope that helps
Nabil Mourad