Xlookup with Hyperlink

Occasional Visitor

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 data, but using Xlookup does not return the link, only the text.

 

For norwegian users:

Jeg bruker denne formelen for andre data. hvordan kan jeg få med hyperlink:

=XOPPSLAG(B7;KUartnr;KUbandinfo;0;0;1)

9 Replies

@PLSVE Wrap your XLOOKUP formula in a HYPERLINK function. Something like this:

 

=HYPERLINK( < your formula > )

@Riny_van_Eekelen

 

When i wrap the formula with =hyperlink(... it hyperlinks to my one drive account instead of the link I assigned it to

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 

@TEXASFOREVER1936 

 

Clear this:

Patrick2788_0-1660070112725.png

 

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.

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

@TEXASFOREVER1936 

I gave the sample in other your thread. 

Still no luck. I have been stumped on this issue for three days. @Sergei Baklan