Formula to return data using hyperlink?

M

Mohamed

i want to make formula to return data from another excel sheet using
hyperlink to this sheet??
 
P

Pete_UK

Why use HYPERLINK? VLOOKUP or INDEX/MATCH can do this for you.

Hope this helps.

Pete
 
M

Mike H

Hi,

A hyperling would take you to the location but to return the value try this

=Sheet1!A1

Mike
 
Top