Thanks Bill,

I will try it tommorrow and will let you know

Many Thanks

Bill Manville wrote:
=HYPERLINK(C15) (which is what your formula is equivalent to) will
create a hyperlink to whatever text is in C15.

I think you may be wanting the cell containing the formula to act as a
hyperlink to the same document as the hyperlink in the cell in 'LOOKUP
LOG'!A2:A1501 which contains the text that is visible in C15.

If so, the only way to do that would be via a VBA function.
Function GetHyperlink(R As Range) As String
If R.Hyperlinks.Count=1 Then
GetHyperlink = R.Hyperlinks(1).Address
If R.Hyperlinks(1).SubAddress<"" Then
GetHyperlink=GetHyperlink & "#" & R.Hyperlinks(1).SubAddress
End If
End If
End Function

Then in your cell you would have
=HYPERLINK(GetHyperlink(INDEX('LOOKUP LOG'!A2:A1501,MATCH(C15,'LOOKUP
LOG'!A2:A1501,0))))

(Partially untested)

Bill Manville
MVP - Microsoft Excel, Oxford, England
No email replies please - respond to newsgroup

--
Message posted via http://www.officekb.com