Excel Lookup 2003

Topic

New Reply

Hi

I was wondering if it is possible to look up information on another sheet by using the sheet name.

Say I have a Sum sheet and on that sheet I have in Column A the Sheet names, then I have the same headings as on the other sheets (A, B, etc)
Can I have a formula under the headings on the Sum sheet to bring back the info from say sheet B by just changing cel A2 on the Sum sheet?

I attach a small file in case my explanation is not clear.

Reply | Quote

Replies

In Sheet ‘Sum’ try these formulas in the respective cells:

Cell B2 =INDIRECT(“‘”&A2&”‘!A”&ROW())
Cell C2 =INDIRECT(“‘”&A2&”‘!B”&ROW())
Cell D2 =INDIRECT(“‘”&A2&”‘!C”&ROW())

Reply | Quote

John

Thank you very much, look so easy, but obviously you need to know the answer first.

Thank you again

Reply | Quote