Forum Discussion

Fatdave42's avatar
Fatdave42
Copper Contributor
Jul 01, 2021
Solved

using = to get data from a sheet based on a cell name

Hi.   I am using =HYPERLINK("#'"&A5&"'!A1",A5) to make a link to a sheet with the sheet name in cell A5.   This works very whell and save me doing a link for every new sheet.   What I would lik...
excel
  • mtarler's avatar
    mtarler
    Jul 01, 2021

    Fatdave42 , the solution HansVogelaar gave will do that.  More specifically the 

    INDIRECT("'" & A5 & "'!F1")

    portion will return the value from cell F1 on the sheet named in cell A5.

    Note: I did find a typo in the formula missing a quote so that might have been part of your problem.

HansVogelaar's avatar
HansVogelaar
MVP
Jul 01, 2021

Fatdave42 

Use

 

=HYPERLINK("#'"&A5&"'!A1",INDIRECT("'"&A5&"'!F1"))

 

Fatdave42's avatar
Fatdave42
Copper Contributor
Jul 01, 2021

I am not after a hyperlink to the information, i am just after the information to show on the master sheet, but using the sheet name that is on the master sheet.