Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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" |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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" |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Hyperlinks: Hyperlinks change on copy/paste? | Excel Worksheet Functions | |||
Update 2000 Excel hyperlinks to 2003 hyperlinks | Excel Worksheet Functions | |||
How toi turn-off hyperlinks [excel]? Email hyperlinks pop up ! | Excel Discussion (Misc queries) | |||
Excel Hyperlinks- cell content v. hyperlinks | Excel Discussion (Misc queries) | |||
Hyperlinks | Excel Worksheet Functions |