Hyperlink via Xlookup

[heathball]

I am using this formula with the full file path

=HYPERLINK("[filepath]2020a!"&CELL("address",A2),"click")

and it works on the sheet. The "click" in B2 links correctly to A2

When i use this....

=HYPERLINK(XLOOKUP($E2,'2020a'!$A:$A,'2020a'!$B:$B,"#",))

to access the link on another sheet.
The 'click' returned from the Xlookup returns this message.

am i missing something?

If i copy the original link, and place it on the new sheet, it works, and links correctly to the cell in the hyperlink.
But the XLOOKUP is not achieving the result?

 

[heathball]

i think this is the issue.
On sheet1, where the hyperlinks are returned via XLOOKup,
this is the address when "edit hyperlink" is selected.
it is linking to this number, for reasons unknown.