Copying Hyperlinks

[Tim]

Help.

I have one spreadsheet containing part numbers in column A and hyperlinks in
column B (which links to their corresponding datasheet on a network drive). I
have a seperate spreadsheet where i am trying to pull across the
corresponding hyperlink using a Vlookup formula on the part numbers. This
works fine, however it only pulls across the text and the hyperlink
disappears, any suggestions?
Hair pulling out time!!

Thanks in advance

[tony h]

try
=hyperlink(ref) where ref is your vlookup

regards

[Tim]

Tried that no joy....
FYI here is my formula

=HYPERLINK(VLOOKUP(A12788,'O:\ADMIN\[CSR
Register.xls]Sheet1'!$1:$65536,6,FALSE))

"tony h" wrote:

>
> try
> =hyperlink(ref) where ref is your vlookup
>
> regards
>
>
> --
> tony h
> ------------------------------------------------------------------------
> tony h's Profile: http://www.excelforum.com/member.php...o&userid=21074
> View this thread: http://www.excelforum.com/showthread...hreadid=529567
>
>

[tony h]

More precise detail is needed to workout what is going on

regards