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 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.