reference work sheet name by using a formula

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

worksheet reference by label - 12 Feb 2008 20:30 GMT

I have multiple sheets. Instead of using the harcode sheet name and the
reference cell in that sheet, is there a way to refer to the worksheet name
using a label.

I want to copy a value from sheet named "XYZ" cell "F5" to my current Sheet1
cell "A2".

Usual way is cell "A2" in Sheet1 would contain the ='XYZ'!$F$5.

Can I have a cell "A1" in Sheet1 with the value XYZ. Then my formula would
refer to that cell "A1". example =A1!F5

Reply to this Message

Teethless mama - 12 Feb 2008 20:40 GMT

=INDIRECT(A1&"!F5")

> I have multiple sheets. Instead of using the harcode sheet name and the
> reference cell in that sheet, is there a way to refer to the worksheet name
[quoted text clipped - 7 lines]
> Can I have a cell "A1" in Sheet1 with the value XYZ. Then my formula would
> refer to that cell "A1". example =A1!F5

Reply to this Message

Tyro - 12 Feb 2008 20:40 GMT

If A1 contains XYZ you can use in A2:

=INDIRECT(A1&"!F5) to get the value from XYZ!F5

Tyro

>I have multiple sheets. Instead of using the harcode sheet name and the
> reference cell in that sheet, is there a way to refer to the worksheet
[quoted text clipped - 10 lines]
> would
> refer to that cell "A1". example =A1!F5

Reply to this Message

Tyro - 12 Feb 2008 20:45 GMT

Correction:

=INDIRECT(A1&"!F5") to get the value from XYZ!F5

> If A1 contains XYZ you can use in A2:
>
[quoted text clipped - 16 lines]
>> would
>> refer to that cell "A1". example =A1!F5

Reply to this Message