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
|