=hyperlink using sheet name from named range

[Youngdand]

HI All,

i have the following formula:

=HYPERLINK("'"&MTEAM1&"'"&"!", "LIZ T")

the formula accepts fine, but does not work

the Value of MTEAM1 is "Liz T" and i have a sheet called "Liz T"

but when the hyplerlink is clicked it just states cannot fin specified file

any ideas on how to overcome this? i have tried using indirect and failed, but it maybe me on that front.

Thanks in advance,


Dan.

 

[Youngdand]

bump