Idexing Question

C

carl

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

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
 
C

carl

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 ?
 
D

dq

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

DQ
 
T

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
 
Top