Showing hyperlink when using lookup

Hi,

Excel's formulas return values, they will not return the associated
hyperlink or comment or error checking message.

You might be able to right a custom VBA function that will do this for you.

Here is a sample, that doesn't quite do what you want but it might start you
on the way

Function RETURNHYPERLINK(Rng As Range) As String
If Rng.Hyperlinks.Count> 0 Then
RETURNHYPERLINK = Rng.Hyperlinks(1).Address

If Len(RETURNHYPERLINK) = 0 Then
RETURNHYPERLINK = Rng.Hyperlinks(1).SubAddress
End If
End If
End Function

This function, entered as =ReturnHyperlink(A1) would return the hyperlink
of cell A1.

If this helps, please click the Yes button.

Cheers,
Shane Devenshire

"OX_Gambit" <OXGambit.TakeThisOut@discussions.microsoft.com> wrote in message
news:4DD0592B-9E76-4CF2-8CA8-D66BB7C97657@microsoft.com...
> I have one sheet that has a list that contains some text that has
> hyperlinks
> and then I use lookup ona different sheet, but when the text is displayed
> onthe second sheet the hyperlink is not there. Is there a way of keeping
> the
> hyperlink on the second sheet. The hyperlink uses tags.