Thread: Formula to return data using hyperlink?
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Mike H Mike H is offline
external usenet poster
  
Posts: 11,501
Default 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 With QuoteReply With Quote