can formula to read sheetname from a cell?
 

I have a formula with references to other worksheets. Is there a way to have
the formula read the sheet name from another cell?

Worksheet(1)
Sheet name Formula I have now: Formula I hope for:
Bob =Bob!c3 =sheetname(This sheet A1)!c3

Jill =Jill!c3 =sheetname(This sheet
A2)!c3
Peter =Peter!c3 =sheetname(This sheet A3)!c3


Thanks,


Todd

Hi
=INDIRECT("'" & A1 & "'!C3")

--
Regards
Frank Kabel
Frankfurt, Germany

"Todd" schrieb im Newsbeitrag
...
I have a formula with references to other worksheets. Is there a way
to have
the formula read the sheet name from another cell?

Worksheet(1)
Sheet name Formula I have now: Formula I hope
for:
Bob =Bob!c3 =sheetname(This sheet
A1)!c3

Jill =Jill!c3 =sheetname(This
sheet
A2)!c3
Peter =Peter!c3 =sheetname(This sheet
A3)!c3


Thanks,


Todd

One way

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

Regards,

Peo Sjoblom


"Todd" wrote:

I have a formula with references to other worksheets. Is there a way to have
the formula read the sheet name from another cell?

Worksheet(1)
Sheet name Formula I have now: Formula I hope for:
Bob =Bob!c3 =sheetname(This sheet A1)!c3

Jill =Jill!c3 =sheetname(This sheet
A2)!c3
Peter =Peter!c3 =sheetname(This sheet A3)!c3


Thanks,


Todd