Referencing worksheet names from a list??

  • Thread starter Thread starter Ace70
  • Start date Start date
A

Ace70

Hi

On one of my worksheets, I have a vertical list of all the worksheet
names that are in the xls file.

Next to each worksheet name in the list, I am trying to create a
formula that references the worksheet name and returns a particular
cell value within that worksheet.

I have been tinkering with the INDIRECT function but can't seem to
string it all together.

Any clues on how to do this?

Cheers

Bull
 
Try this:

A1 = Sheet Name

=INDIRECT("'"&A1&"'!B27")

Which evaluates to:

='Sheet Name'!B27
 
Back
Top