Forum Discussion

PLSVE's avatar
PLSVE
Copper Contributor
Nov 12, 2021

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...
excel
TEXASFOREVER1936's avatar
TEXASFOREVER1936
Copper Contributor
Aug 09, 2022

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

  • RevansN86's avatar
    RevansN86
    Copper Contributor
    Oct 21, 2022

    TEXASFOREVER1936maybe this is a bit late but I found a solution while I had a similar problem using a custom function to create a new column with the urls, then pointed the xlookup toward that column.

     

    this page solved it for me: https://excel.tips.net/T003281_Extracting_URLs_from_Hyperlinks.html

    Function GetURL(rng As Range) As String
    On Error Resume Next
    GetURL = rng.Hyperlinks(1).Address
End Function

    if the hyperlink is in cell A1 and you want the full url in cell B1, then in B1 you would enter =getURL(A1)

    see https://support.microsoft.com/en-us/office/create-custom-functions-in-excel-2f06c10b-3622-40d6-a1b2-b6748ae8231f if you need help with VBA custom functions to set it up

     

    worked great for me.

  • TEXASFOREVER1936's avatar
    TEXASFOREVER1936
    Copper Contributor
    Aug 09, 2022

    Still no luck. I have been stumped on this issue for three days. SergeiBaklan 

Resources