across worksheets

Posted by Jim on August 21, 2001 9:40 AM

I have a spreadsheet with multiple rows of data. The 1st
column contains the names of the other sheets in the file.
Is there a way to have excel look at the data in column
1 so that it knows to look in the sheet that matches
column 1 for the information I need to find?

Posted by IML on August 21, 2001 9:54 AM

Lets say you want to find the value for of G14 on Sheet2.
Sheet2 is listed is cell A1. Try
=INDIRECT(A1&"!g1")

If cell A1 reads Sheet2!, then simply
=INDIRECT(A1&"g1")

good luck.

Posted by Mark W. on August 21, 2001 9:54 AM

Use the INDIRECT worksheet function. For example,
if A1 contains "Sheet2" then =INDIRECT(A1&"!A1")
will return the value from Sheet2!A1.