Hi Bill,
Thanks for reply
I have just tried it but still no luck.
I have done the VB function and then copied the formula you told me and in
cell it says #NAME?
=HYPERLINK(GetHyperlink(INDEX('LOOKUP LOG'!A2:A1501,MATCH(C15,'LOOKUP
LOG'!A2:A1501,0))))

Any thoughts.

Regards


Bill Manville wrote:
Alt+F11 to VB editor
Insert Module
Paste the code into the code window that will appear top right

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

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...links/200806/1