Hi,
I have a vlookup pointing at cells which have a hyperlink to a website. The hyperlinks are 'hidden', and the cells only show the "text to display", and not the links.
So my vlookup returns the text rather than the links themselves.
How can my vlookup return the actual links?
=HYPERLINK(VLOOKUP(B21,Links!E:H,4,0))
Thanks
M
Bookmarks