Getting values from hyperlink
Does someone has an answer for the question below?
I have a cell (say A1) with the formula:
=HYPERLINK(€œ[d:\tmp\file.xls]sheet!B11")
In the next cell, I would like to see the value that the cell pointed by the
hyperlink has. I tried:
=INDIRECT(A1)
But Excel gives a #REF error in the INDIRECT function.
Does someone have any idea on how can I solve this?
Thanks a lot
Antonio Duarte.
|