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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Hyperlinking automatic?? 1
Newbie Help - IF Yes No Function 0
Hyperlink to open new window within document 0
You'll need a new app to open this about link 1
Can UDF return a customized hyperlink? 3
Use TODAY() function as the criteria in a SUMIF formula 1
Avoiding auxiliary cells 0
Vlookup and return sheet name also 2

Top