| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula to return data using hyperlink?
i want to make formula to return data from another excel sheet using
hyperlink to this sheet?? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Formula to return data using hyperlink?
Why use HYPERLINK? VLOOKUP or INDEX/MATCH can do this for you.
Hope this helps. Pete On Dec 11, 2:59*pm, Mohamed wrote: i want to make formula to return data from another excel sheet using hyperlink to this sheet?? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Formula to return data using hyperlink?
Hi,
A hyperling would take you to the location but to return the value try this =Sheet1!A1 Mike "Mohamed" wrote: i want to make formula to return data from another excel sheet using hyperlink to this sheet?? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel Web Query does not return hyperlink | Excel Discussion (Misc queries) | |||
| formula required to return data from one column | Excel Worksheet Functions | |||
| Sumproduct - formula to return data OTHER than given criteria | Excel Worksheet Functions | |||
| To return value that provide data to a formula | Excel Worksheet Functions | |||
| Intra-workbook hyperlink: macro/function to return to hyperlink ce | Excel Discussion (Misc queries) | |||
Linear Mode
