Problem:

Column A contains two range Names that have been defined for two cells in Sheet1 of Book1.xls.
We want to create a formula to retrieve the values stored in each of these range Names.

Solution:

Use the INDIRECT function as shown in the following formula:
=INDIRECT(\"[Book1.xls]Sheet1\'!\"&A2&\"\")