Forum Discussion

mbartolucci's avatar
mbartolucci
Copper Contributor
Jul 29, 2019

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...
excel
nabilmourad's avatar
nabilmourad
MVP
Jul 31, 2019

mbartolucci 

Here is a screenshot with the functions created

Hope that helps

Let me know

Nabil Mourad

  • mbartolucci's avatar
    mbartolucci
    Copper Contributor
    Jul 31, 2019

    nabilmourad Oh I think I understand the problem. It is linking to the cell beside it correct?

    So in the file, under 'index', i have a room number which corresponds with a tab. so for example, in the index, I want to have the cell beside room number 0004 (under Room Name column, B) to link to tab 0004, and to name itself with whatever is written in cell A1 of sheet 0004. Perhaps thats what you are already saying and I simply dont understand..

      • mbartolucci's avatar
        mbartolucci
        Copper Contributor
        Jul 31, 2019

        nabilmourad Since I cant seem to attach the file, here is a one drive link to the file instead

        https://1drv.ms/x/s!Ap5GfAPWJw6r2V5WgF57CH34LU1z?e=jflxpd

Resources