Forum Discussion
Solved
HYPERLINK w/XLOOKUP Receiving ERR_INVALID_RESPONSE "The site can't be reached"
I have a shared excel workbook on a SharePoint site that has several tabs. TabA = Projects listed and direct urls to Project IDs in a SharePoint list for updating quickly. TabB = References TabA...
Sorry, forgot # in front. Depends on which kind of references you use it could be
Please check in attached file.
In HYPERLINK first parameters is the text, not returned reference. That could be like
= HYPERLINK( CELL("address", XLOOKUP(C476,Table3[Projects],Table3[Ref]) ) )
Thank you. However, I am getting #VALUE! now.