ExcelBanter - Formula to return data using hyperlink?

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Formula to return data using hyperlink? (https://www.excelbanter.com/excel-worksheet-functions/250828-formula-return-data-using-hyperlink.html)

Mohamed

Formula to return data using hyperlink?

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

Pete_UK

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??

Mike H

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??

All times are GMT +1. The time now is 12:02 PM.