vlookup not returning hyperlink to another cell in the workbook

[michellehemmings]

So i have a contents page which holds my vlookup

=VLOOKUP(C8,'Content Summary'!1:1048576,2,FALSE)

and a content summary page which holds a full list of sheets and sheet sections in my workbook.

The vlookup on the contents page pulls the correct data but doesn't pull through the hyperlink to the cell

I am trying to create a user friendly drop down contents page instead of people having to scroll down a 6 page document to find the relevant section in the workbook they require before clicking the link

I have tried

=HYPERLINK(VLOOKUP(C8,'Content Summary'!1:1048576,2,FALSE)​

However this doesn't work as my link is a "place in this document" link

PLEASE HELP!

 

[michellehemmings]

Hi Ed
One more question sorry!

So this is my current formula working perfectly thanks toyou!

However, if the cell is blank on the contents summary sheethow do I get it to return blank instead of #value ?
=HYPERLINK(GetURL_CS(MATCH(C8,'ContentSummary'!A:A,0),2),(VLOOKUP(C8,'Content Summary'!1:1048576,2,FALSE)))

I previously used the below formula but I cant seem to getthis incorporated with the above formula
=IF(LEN(VLOOKUP(C8,'ContentSummary'!1:1048576,7,FALSE))=0,"",(VLOOKUP(C8,'ContentSummary'!1:1048576,7,FALSE)))

Thank You!

Michelle

 

[edmitchell]

Hi

this should work/do what you need:

=IF(ISBLANK(VLOOKUP(C8,'Content Summary'!1:1048576,2,FALSE)),"",HYPERLINK(GetURL_CS(MATCH(C8,'Content Summary'!A:A,0),2),(VLOOKUP(C8,'Content Summary'!1:1048576,2,FALSE))))

regards

Ed