Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.links
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
vlookup results in 0 | Excel Discussion (Misc queries) | |||
Vlookup with two results | Excel Discussion (Misc queries) | |||
answer to odd results when comparing hyperlink addresses | Links and Linking in Excel | |||
Can I have mulitple web page results from a Hyperlink? | Excel Discussion (Misc queries) | |||
How do I annotate the cell results from Excel to a Hyperlink? | Excel Discussion (Misc queries) |