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.

Try this:

A1 = A
A2 = B
A3 = C
etc

Enter this formula in B1 and copy down as needed:

=INDIRECT(A1&"!L1")

Biff

"carl" wrote in message
...
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.

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

"T. Valko" wrote:

Try this:

A1 = A
A2 = B
A3 = C
etc

Enter this formula in B1 and copy down as needed:

=INDIRECT(A1&"!L1")

Biff

"carl" wrote in message
...
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.

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 ?

"T. Valko" wrote:

Try this:

A1 = A
A2 = B
A3 = C
etc

Enter this formula in B1 and copy down as needed:

=INDIRECT(A1&"!L1")

Biff

"carl" wrote in message
...
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.

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

DQ

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

"carl" wrote in message
...
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 ?

"T. Valko" wrote:

Try this:

A1 = A
A2 = B
A3 = C
etc

Enter this formula in B1 and copy down as needed:

=INDIRECT(A1&"!L1")

Biff

"carl" wrote in message
...
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.