How do I have a formula lookup a sheetname?

G

Guest

I have a workbook with multiple worksheets.
Sheet 1: Has information needed to be retrieved and put into specific cells on
Sheet2.
Sheet 2: Col. A lists names of worksheets in workbook
In Col. B I want to write a formula that will lookup the
worksheet, using
the worksheet name in Col. A, then retrieve a value in a
specific cell on
that worksheet.

I don't want to "hardcode" the name of the worksheet in the formula (i.e.
'Sheet1'!H14), because that sheetname will always be changing.
 
G

Guest

You can use INDIRECT, assume A2 holds the sheet name

=INDIRECT("'"&A2&"'!H14")


Regards,

Peo Sjoblom
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do I lookup the sheetname in a workbook 2
Excel How to capture data to a specified excel sheet(first workbook) of two different workbooks from the 0
can formula to read sheetname from a cell? 2
Lookup Formula 4
Match with 3 criteria 3
USe Contents of cell as name of worksheet in a function 5
Lookup formula with dynamic sheet reference 5
Using a cell to reference sheetname in vlookup function 1

Top