Xlookup to return cell text + hyperlink

[Jobb1Excel]

Hey, im looking for a formula that returns the hyperlink from the result of the xlookup from another sheet.

i got a "sheet1" and "sheet2": In the "sheet1" im using xlookup to find job descriptions (each material number has a job description file linked to the cell), but when i use the xlookup to get the job description for each material number it only returns the cell text and not the hyperlink from the cell. I have tried =hyperlink with no luck...

Cell A1-A4 is the cells with hyperlink im using xlookup to find. But the result i get is example: 1 and no link.

 

[Jobb1Excel]

Did you put the code for the function ExcelToDAX gave you in post #2 into a standard module and save your workbook as xlsm ?

Yes i did.

 

[Fluff]

That is not a standard module, it's a sheet module.

 

[Jobb1Excel]

That is not a standard module, it's a sheet module.

My bad. Changed it now.

it returns 5 with a link, but i cant open it.

 

[Jobb1Excel]

Still looking for a solution for this.

 

[Alex Blakenburg]

Can you add the debug.print line to the Function and see if what you get in the immediate window makes sense and maybe copy that into a URL address box and see if it works.
If you can't see the immediate window then when you are in VBA type Ctrl+G

Function GetURL(cell As Range) As Variant
    GetURL = cell.Hyperlinks(1).Address
    Debug.Print GetURL
End Function