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...
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".
I gave the sample in other your thread.
Still no luck. I have been stumped on this issue for three days. SergeiBaklan