Combine Hyperlink and Indirect formula?

[shane_aldrich]

Hi all,

I suck at using indirect formulas...trying to combine indirect and hyperlink

for example

Cell a11 = Regional_Market_Performance

so in cell i2 i have this formula...it works, perfect

=HYPERLINK("#'Regional_Market_Performance'!A1",A11)

so instead i tried this in cell i2

=HYPERLINK(INDIRECT(A11&"!A4"),A11)

but when i click the link i get an error "Cannot open the spcified file"

Any help would be grand!

Thanks,

 

[Rosen]

INDIRECT requires the value in the cell referenced to provide the reference of what INDIRECT returns. I think what you want to have is something like this:

=HYPERLINK("#'" & A11 & "'!A4", A11)

Hope that helps!