can formula to read sheetname from a cell?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
Back
Top