» 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:
- The 11 Immutable Laws of Internet Branding
- Preparing the Marketing Plan (Ama Marketing Toolbox Series New Edition)
- VBA for Modelers: Developing Decision Support Systems Using Microsoft« Excel
- The South Beach Diet: The Delicious, Doctor-Designed, Foolproof Plan for Fast and Healthy Weight Loss
- East of Eden (Oprah's Book Club)
- Investing for Dummies, Third Edition
No comments have been submitted.
