» Retrieving Values from another Sheet Using Date as Sheet Name Reference
CATEGORY - Lookup Formulas
VERSION - All Microsoft Excel Versions
The dates entered in column A ("mmm-yy") refer to sheets with corresponding names (mmyy).
We want to create a formula to retrieve value in cell A1 from a sheet referred to by each of the dates in column A.
Solution:
Use the INDIRECT and TEXT functions as shown in the following formula:
=INDIRECT(TEXT(A2,"mmyy")&"'!A1")
Book Store:
Recommended Books:
- Positioning: The Battle for Your Mind
- Quantitative Methods in Derivatives Pricing: An Introduction to Computational Finance
- Rich Dad's Guide to Investing: What the Rich Invest in, That the Poor and the Middle Class Do Not!
- Managerial Accounting: Tools for Business Decision Making, WebCT, 2nd Edition
- Windows XP Annoyances
- The Total Money Makeover. : A Proven Plan for Financial Fitness
No comments have been submitted.
Excel Formula and Function
Excel Date and Time
Excel Macros and VBA
Excel Text, Editing and Format
Excel General
Excel Data
