M Mohamed Dec 11, 2009 #1 i want to make formula to return data from another excel sheet using hyperlink to this sheet??
P Pete_UK Dec 11, 2009 #2 Why use HYPERLINK? VLOOKUP or INDEX/MATCH can do this for you. Hope this helps. Pete
M Mike H Dec 11, 2009 #3 Hi, A hyperling would take you to the location but to return the value try this =Sheet1!A1 Mike
