Forum Discussion

RaeesaB's avatar
RaeesaB
Copper Contributor
Oct 17, 2022

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...
excel
Formulas and Functions
SST12's avatar
SST12
Copper Contributor
Aug 21, 2024

RaeesaB 

 

Have you had a viable solution? Since hyperlink needs two parameters, you need to nest two vlookups; one vlookup for the link location and one vlookup for the friendly name.

=HYPERLINK(VLOOKUP(lookup value,table array,column,false),VLOOKUP())

 

Here was mine:

 

Resources