Forum Discussion
Xlookup with Hyperlink
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.
- TEXASFOREVER1936Aug 09, 2022Copper Contributor
Still no luck. I have been stumped on this issue for three days. SergeiBaklan
- RevansN86Oct 21, 2022Copper Contributor
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 here if you need help with VBA custom functions to set it up
worked great for me.