View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.links
takhan takhan is offline
external usenet poster
 
Posts: 1
Default VLOOKUP RESULTS AS A HYPERLINK

Gents,

I need your help please in creating a vlookup sheet.
I have got xl file with two sheets; lookup report and lookup log. I am trying
to show vlookup result as a hyperlink. column A on log has got some file
names which I am searching on report. the file names in log also hyperlink to
some files on network. I am trying this formula
=HYPERLINK(VLOOKUP(C15, 'LOOKUP LOG'!A2:Z1501, 1, 0)). Also does it matter
where this formula in report sheet should be typed in, as this formula is in
D4 in report sheet

Any idea what I am doing wrong????

Please help.

Many Thanks in advance