Hyperlinks
 

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

=VLOOKUP(E19,Datasheet!A2:Datasheet!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"

Hyperlinks
 

Hi Bill,
For an example of using VLOOKUP with a HYPERLINK Worksheet Function see my sheets.htm page.
http://www.mvps.org/dmcritchie/excel....htm#hyperlink
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Bill" wrote in message ...
I use the following formula to retrive information for another sheet and
display it on the working sheet;

=VLOOKUP(E19,Datasheet!A2:Datasheet!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"