» Retrieving Values Using Range Names as References
CATEGORY - Lookup Formulas
VERSION - All Microsoft Excel Versions
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&"")
Book Store:
Recommended Books:
- Special Edition Using Microsoft Excel 2002
- Managerial Accounting: Tools for Business Decision Making, WebCT, 2nd Edition
- A Mathematician Plays the Stock Market
- Financial Statement Analysis: A Practitioner's Guide, 3rd Edition
- The Financial Numbers Game: Detecting Creative Accounting Practices
- Microsoft Windows XP Inside Out
No comments have been submitted.
