Tip Printed from ExcelTip.com

---

Retrieving Values Using Range Names as References


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&"")