Hyperlinks

[Guest]

I use the following formula to retrive information for another sheet and
display it on the working sheet;

=VLOOKUP(E19,Datasheet!A2atasheet!E2502,2,FALSE)


It works well, but what what I would like to do is incorarate the formula
into a hyperlink so that it would jump me to the information instead of
adding it to the sheet. Something aling the lines of;

Workbook.xls#'datasheet'!"Vaule of active cell"

 

[David McRitchie]

Hi Bill,
For an example of using VLOOKUP with a HYPERLINK Worksheet Function see my sheets.htm page.
http://www.mvps.org/dmcritchie/excel/sheets.htm#hyperlink