» 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:
- Monte Carlo Methods in Finance
- Essentials of Investments with Standard & Poor's Educational Version of Market Insight + PowerWeb + Stock Trak Coupon
- Accounting the Easy Way
- Microsoft Outlook 2002 for Dummies
- Microsoft Word Version 2002 Step By Step (With CD-ROM)
- Marketing Plans That Work, Targeting Growth and Profitability
No comments have been submitted.
