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 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)
10 Replies
PLSVE Wrap your XLOOKUP formula in a HYPERLINK function. Something like this:
=HYPERLINK( < your formula > )
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
