» Retrieving Values from Different Sheets Using the Sheet Name as a Reference
CATEGORY - Lookup Formulas
VERSION - All Microsoft Excel Versions
Problem:Listed in columns A & B are first and last names.
Each of those names has a matching worksheet, named in the following format: "FirstName LastName".
We want to create a formula to retrieve the cell A1 from the sheet that matches each name.
Solution:
Use the INDIRECT function as shown in the following formula:
=INDIRECT("'"&A2&" "&B2&"'!A1")
Book Store:
Recommended Books:
- Getting to Yes: Negotiating Agreement Without Giving In
- Excel Charts
- Rich Dad's Guide to Investing: What the Rich Invest in, That the Poor and the Middle Class Do Not!
- Final Accounting: Ambition, Greed and the Fall of Arthur Andersen
- Good to Great: Why Some Companies Make the Leap... and Others Don't
- VBA for Modelers: Developing Decision Support Systems Using Microsoft« Excel
No comments have been submitted.
