VLOOKUP and links in the linked cell

Hey community,

if I use VLOOKUP , and the linked cell (Cross reference to another sheet) itself contains a link, the result in the cell, where the Vlookup formula is inside, returns aonly the text from the link but not the link itself.

Any idea?

Thanks Kay