» 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:
- Business Analysis and Valuation: Using Financial Statements, Text and Cases
- Your First Business Plan: A Simple Question and Answer Format Designed to Help You Write Your Own Plan (3rd Ed)
- Fish! A Remarkable Way to Boost Morale and Improve Results
- Mortgages For Dummies®
- Microsoft Office Xp: Advanced Concepts and Techniques: Word 2002, Excel 2002, Access 2002, Powerpoint 2002
- Harry Potter and the Order of the Phoenix (Book 5)
No comments have been submitted.
