Forum Discussion
Fetching VLOOKUP value with embedded hyperlink
I am trying to fetch a value from another sheet in the workbook from a cell which also has a hyperlink embedded. However, VLOOKUP only fetches the text and not the embedded hyperlink. How to get it t...
Thank you so much for taking the time to do this!! I'm so so grateful. If I understand correctly, this only works if links are created with HYPERLINK function as you specified. Sadly this is not the case for my data base 😞
Hi! If you haven't found a better solution yet, I can offer you to convert your cells with the links into functions with HYPERLINK(). I have found a macro for this on the net. However, it only works with LibreOffice Calc. I'm sure you can find one for Excel. But since I use Excel for the web, I cannot design / execute macros in Excel.
Copy your cells with the links into a new worksheet and send it to me. I will convert and send it back to you if you want.
It's just an offer to get you started.