Idexing Question

[Guest]

I have a workbook that has worksheets named A,B,C...Z.

I have a worksheet where ColumnA lists the worksheet names.

Is there a formula that I can use in ColB that will look at the worksheet
name in ColA and return the value in Row1, Col12 of the relevent worksheet ?

Thank you in advance.

 

[T. Valko]

Try this:

A1 = A
A2 = B
A3 = C
etc

Enter this formula in B1 and copy down as needed:

=INDIRECT(A1&"!L1")

Biff

 

[Guest]

Thanks. Tried this but could not get it to work (REF). Any thoughts ?

 

[Guest]

Hi. When I wrote "I have a workbook that has worksheets named A,B,C...Z." I
was generalizing. The actual names of the worksheets vary. For example

Jan 2(2)
Jan 3

Does that help in troubleshooting your suggestion ?

 

[dq]

Change the formula to
=INDIRECT("'" &A7&"'!A1")
Make sure to have all the double and single quotes as mentioned

DQ

 

[T. Valko]

Does that help in troubleshooting your suggestion ?

Yes!

Let this be an example of why you should tell us what you really have!

When sheet names have spaces in them you must enclose the name in single
quotes:

Try it this way:

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

Biff