HYPERLINK w/XLOOKUP Receiving ERR_INVALID_RESPONSE "The site can't be reached"

[ellie5225]

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 to select a project from drop down. The team requested to also several of the other fields over to TAbB based on thier selection including the Hyperlink.

---------------------------------------------------------------------------------------

I used this forumla previously and it worked, now it no longer works. It still populates the link and friendy name ID=###; however will not open. TabA the urls all work.

=IFNA(HYPERLINK(XLOOKUP(C476,Table3[Projects],Table3[Ref],)),"Select a Project Assignment in column C")

-----------------------------------------------------------------------------

This site can't be reached

ERR_INVALID_RESPONSE

Any help would be greatly appreciated. Thank you in advance.

[#2]

@ellie5225 

In HYPERLINK first parameters is the text, not returned reference. That could be like

= HYPERLINK( CELL("address", XLOOKUP(C476,Table3[Projects],Table3[Ref]) ) )

[#3]

Thank you. However, I am getting #VALUE! now.

[#4 · Accepted solution]

@ellie5225 

Sorry, forgot # in front. Depends on which kind of references you use it could be

Please check in attached file.

[#5]

Thank you so much!

[#6]

@ellie5225 , you are welcome