View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
corlev corlev is offline
external usenet poster
 
Posts: 1
Default 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