I want to copy a hyperlink in sheet 1 to sheet 3.

March 22, 2013 at 05:08:38
Specs: Windows 7
Sheet 3 uses a VLOOKUP and returns the hyperlink text but only as text and not a hyperlink.
Please help!!

See More: I want to copy a hyperlink in sheet 1 to sheet 3.

Report •

March 22, 2013 at 08:44:44
Sorry, not sure I understand what it is your trying to do.

A =VLOOKUP() will not return a true =HYPERLINK(),
but you can use a =VLOOKUP() to populate a =HYPERLINK()
where the cells you return from your =LOOKUP() contain the path for your hyperlink.



Report •

March 22, 2013 at 13:30:41
Thanks for the reply. I managed to sort it out ALMOST.

I used the following formula and all works fine within the sheet 2. The text "Info" appears in the cell and when clicking it, it takes you to the website/hyperlink that I put in on sheet 1.


The problem I have now is that I need to save the sheet as a PDF file and the hyperlink does not work within the PDF unless I remove the friendly name "Info". If the web address is shown instead of the friendly "Info" that works fine but some of the addresses are really long and I need a friendly text to be shown instead of the full URL

Thanks in advance

Report •

March 22, 2013 at 15:27:47
Sorry, I have no knowledge on how Adobe works.



Report •

Related Solutions

March 22, 2013 at 21:11:37
I did a bunch of Google searches and searches of other Excel related forums and all I can find are questions similar to yours, but no solutions. It appears that it just can't be done.

I think I can sort of explain why it doesn't work. Perhaps you already figured this out, so bear with me. If nothing else, this explanation will be stored in the Archives in case someone else needs it.

When the Excel sheet is converted to a PDF, no hyperlinks are transferred to the PDF. Not the ones created with the HYPERLINK function, not the ones automatically created when you type a full URL into an Excel cell, and not the ones created via the Right-Click...Hyperlink feature. The only thing that is transferred to the PDF is the text that was in the cell.

However, similar to the automatic conversion that Excel does when it sees a properly formatted URL, the URL is converted to a hyperlink by the application that created the PDF.

You can prove this to yourself in this manner:

1 -Enter a full URL in an Excel cell - which Excel will automatically convert to a hyperlink.

2 - Right click the cell and choose "Remove Hyperlink". Now you don't have a hyperlink in the cell.

3 - Convert the Excel sheet to a PDF.

That non-hyperlink in the Excel sheet will now be a hyperlink in the PDF document.

In other words, Excel didn't transfer the hyperlink, the hyperlink was created within the PDF simply because the application saw the correct syntax of a hyperlink.

I hope that helps someone.

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

Report •

Ask Question