Single cell with multiple hyperlinks

[garethwhitcombe]

Dear MrExcel,

is there a way to have multiple hyperlinks to various files in one cel?


i want to the hyperlink to change based upon information entered in which i want it to copy an address from another sheet using the V-lookup command.

 

[Jerry Sullivan]

Hi garethwhitcombe,

You can use the Hyperlink() worksheet function to allow a cell's single hyperlink to be dynamic.
That can be coupled with Vlookup or other conditional function, for example...

=HYPERLINK(VLOOKUP("MyLookupName",Sheet2!A:B,2,0))

To clarify, this isn't the same has having multiple hyperlinks in one cell.
As far as I know, a single cell can have only one direct hyperlink.

A somewhat clunky workaround if there's a need for more than one clickable hyperlink in a cell (e.g. a list of addresses) is to place multiple shapes inside the cell and assign a hyperlink to each shape.

 

[BatesAC]

Garethwhitcombe,

I needed to do this along time ago, however could never find a solution other than to 'trick the user'.
I was creating a front end with a locked sheet, and no cell headings so it was not a visible change.

To keep the appearance of Excel I added a very feint grey 'All Borders'. Turn off Grid lines then delete the borders between the 2/3/4 hyperlink cells to give the appearance of only being 1 cell (or write a routine/conditional formatting to do it for you).

Hope this idea works for your project too.

Regards,

Adam

 

[garethwhitcombe]

thanks I managed to get this to work. what i did was vlookup to a hidden cel then use the =Hyperlink function which works perfectly

well almost..... there is one website that requires logging in first before it will provide the linked data sheet. even if you log in and then click- it still goes back to the log in screen.