» 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
- The Fall of Advertising and the Rise of PR
- The Interpretation of Financial Statements
- The 22 Immutable Laws of Marketing : Exposed and Explained by the World's Two
- Financial Statement Analysis: A Practitioner's Guide, 3rd Edition
- The 11 Immutable Laws of Internet Branding
INDIRECT(A33&"!AG28")