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)

1 Reply

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

 

=HYPERLINK( < your formula > )