ExcelBanter - VLOOKUP referencing a cell with a URL

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - VLOOKUP referencing a cell with a URL (https://www.excelbanter.com/excel-worksheet-functions/156479-vlookup-referencing-cell-url.html)

corlev

VLOOKUP referencing a cell with a URL

I am using VLOOKUP to reference a cell on another worksheet. The contents of
that cell is a hyperlinked URL. I would like to have the hyperlinked URL
show up, but the VLOOKUP function returns only the text. How can I modify
the VLOOKUP command to return the hyperlinked URL. Thanks

Gary''s Student

VLOOKUP referencing a cell with a URL

Instead of =VLOOKUP()
use
=HYPERLINK(VLOOKUP())
--
Gary''s Student - gsnu200740

"corlev" wrote:

I am using VLOOKUP to reference a cell on another worksheet. The contents of
that cell is a hyperlinked URL. I would like to have the hyperlinked URL
show up, but the VLOOKUP function returns only the text. How can I modify
the VLOOKUP command to return the hyperlinked URL. Thanks

All times are GMT +1. The time now is 09:59 AM.