Linking Hyperlinks into different cells

[Gav via OfficeKB.com]

I have got a front sheet with several selections to make. This is
transfered onto a hidden sheet where it uses an autofitler to narrow the
search down to one row. On this row there are several numbers which I
transfer onto the front page. I also need to transfer a hyperlink onto the
front sheet.
I can transfer the text of the hyperlink, using this:

{=INDEX(K11:K304,MATCH(1,SUBTOTAL(3,OFFSET(K11:K304,ROW(K11:K304)-MIN(ROW
(K11:K304)),,1)),0))}

I cannot transfer the hyperlink itself, does anyone know how to do this?

Thanks in advance,
Gav

 

[Dave Peterson]

Untested:

=hyperlink(yourformula)

But if this works, it'll make anything that's returned into a link. (It uses
the value in the cell--not the link (added via insert|hyperlink).

 

[Gav via OfficeKB.com]

Cheers Dave, but that didnt work, it gave a hyperlink, but didnt have an
address to go to.

Any other suggestions?

Gav

 

[Dave Peterson]

That =hyperlink() uses the value returned.

If your returned value isn't a valid hyperlink, then maybe you could convert it
to one:

=hyperlink("http://" & yourformula)

If the value returned was missing the http:// portion.

If that doesn't work, what do you see in the cell?