getting a value

[serge]

Hi,

In cells A1 to A500 i have hyperlinks to other workbooks. In cells B1
to B500, i want to create a formula to get the value of the cell A4 of
each hyperlink in the column A. Is this possible?

 

[Guest]

You need to separate the issues...

The fact that you employ a hyperlink to jump you to another location
(workbook, worksheet, or otherwise) is mutually exclusive from the fact that
you want to obtain an explicit value from another location (workbook,
worksheet, or otherwise) in the present cell location...

You the "Index" function Syntax 1 to return the value of a specified cell
from anoth location... in cell B1 use this formula:
=INDEX([test.xls]Sheet1!$A$1:$B$5,4,1)
Where [test.xls] is the name of the workbook
Where Sheet1!$A$1:$B$5 in the location of the data in test.xls
Where 4 is the row number containing the value that you want
Where 1 is the column number containing the value that you want