» 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:
- Microsoft Excel 2002 Formulas (With CD-ROM)
- Keys to Reading an Annual Report (Barron's Business Keys)
- Essentials of Investments with Standard & Poor's Educational Version of Market Insight + PowerWeb + Stock Trak Coupon
- The McGraw-Hill Guide to Writing a High-Impact Business Plan: A Proven Blueprint for First-Time Entrepreneurs
- The Intelligent Investor: The Definitive Book On Value Investing, Revised Edition
- Yes, You Can Time the Market!
No comments have been submitted.
