Forum Discussion
Xlookup with Hyperlink
I have a database of products and in one of the columns we have hyperlinks to the suppliers PDFs. When making a priceless I want to get this link to the priceless. We use Xlookup for all other da...
ANY LUCK? I HAD THE SAME ISSUE AND EVEN WENT AS FAR AS UNLINKING MY PC FROM ONEDRIVE. NOW I JUST HET A "CANNOT OPEN THE SPECIFIED FILE." ERROR MESSAGE. Westy-world
Clear this:
Rebuild link and test again. The hyperlinks might've been breaking on save.
- Thank for your response, I have done that as well. No luck there.
Please check this thread https://techcommunity.microsoft.com/t5/excel/hyperlink-w-xlookup-receiving-err-invalid-response-quot-the-site/m-p/3293279 if something helps.
THANK YOU FOR THE RESPONSE, SO I USED "=HYPERLINK( "#" & XLOOKUP(C6,A6:A7,B6:B7))", IT RETURNED THE CORRECT CELL BUT ERROR MESSAGE "REFERENCE ISNT VALID".
