» Retrieving Values Using Range Names as References
CATEGORY - Lookup Formulas
VERSION - All Microsoft Excel Versions
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&"")
Book Store:
Recommended Books:
- Microsoft Excel 2002 Formulas (With CD-ROM)
- Essentials of Accounting and Post Test Booklet 8, Eighth Edition
- Financial Statements: A Step-By-Step Guide to Understanding and Creating Financial Reports
- Special Edition Using Microsoft Outlook 2002
- The New Financial Order: Risk in the Twenty-First Century
- How to Pay Zero Taxes (Annual)
No comments have been submitted.
