Hi, As specified in the title, does anyone know how to do vlookup but the returned value is still in form of hyperlink to another cell in other worksheet?
I tried using this
=HYPERLINK(VLOOKUP(G82,Data,6,FALSE),"CLICK HERE")
but it doesn't work if the value returned is a hyperlink to another cell.
It only works if it is hyperlink to internet address.