» Retrieving a Specific Cell from Multiple Sheets
CATEGORY - Lookup Formulas
VERSION - All Microsoft Excel Versions
We want to copy the contents of cell A1 from Sheets1-5 into row 2 of the current sheet.
That is, cell C2 of the current sheet is to contain the value stored in cell A1 of Sheet1, cell D2 is to contain the value from Sheet2, and so on.
Solution:
Use the INDIRECT and COLUMN functions as shown in the following formula:
=INDIRECT("Sheet" & COLUMN()-COLUMN($C$2)+1 & "'!$A$1")
Book Store:
Recommended Books:
- Excel 2002 Power Programming with VBA
- The Complete Book of Business Plans: Simple Steps to Writing a Powerful Business Plan (Small Business Sourcebooks)
- Financial Shenanigans : How to Detect Accounting Gimmicks & Fraud in Financial Reports
- Windows XP for Dummies
- The Interpretation of Financial Statements
Hmm
TheShaolin
This is EXACTLY what I need to figure out, however, the example is pretty vague. Can someone please give a better example of how to use this?
Error in Formula
Syed_Haneef
:confused: The formula sounds good, but it seems there's an error in the syntax.
