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

Can UDF return a customized hyperlink? 3
Vlookup and return sheet name also 2
How to return to the previous active sheet after hyperlink? 5
Hyperlinks 2
HYPERLINK Worksheet Function 3
Get Cell Style 2
Hyperlink to another sheet within a workbook using formula 1
Hyperlink Formula Problem 2

Top