» 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:
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.
