Hyperlink 404 error for SharePoint based spreadsheet

[rjalili]

Hi all,

I'm developing a calendar on a SharePoint based excel spreadsheet that maps meetings and relevant submissions, the details of which are on secondary sheets. My goal is to click on the meeting link in the calendar sheet, to be 'sent to' the relevant meeting title in the meetings sheet. I thought this would be an easy combination of HYPERLINK and LOOKUP e.g. =HYPERLINK(LOOKUP("MEETINGNAME",Meetings!A:A)), but every variation of that or even more complex functions like HYPERLINK with ROW and VLOOKUP hidden columns return an error message: "Unable to open [sharepoint address]. The Internet site reports that the item you requested could not be found. [HTTP /1.0 404]" which I provisionally attribute to the area being restricted.

I tried to manually workaround, by hyperlinking cells directly to the meeting in the other sheet, but the link is rendered useless when the second sheet is sorted.

Any advice on fixing the link or a simple workaround is greatly appreciated!

 

[rjalili]

Hi all,

It's okay, I managed to make it work with =HYPERLINK("#'Meetings'!"&ADDRESS(MATCH("Meeting A", Meetings!$A:$A,0),1),"Meeting A")

Thanks