Find a sheet name in a cell?

  • Thread starter Thread starter Jordon
  • Start date Start date
J

Jordon

Is it possible for a formula to translate the contents of a cell to get
a worksheet name?

For instance, I have a sheet named John Smith and a sheet named
Employees. In the sheet named Employees in cell A1, I have the
name John Smith. In cell B1 I need a formula that says something like

=if(a1="","",get the text in A1 and get the contents of C1 from that sheet)

TIA,

Jordon
 
Hi Jordon

yes you can use the INDIRECT function to do this
e.g.

=IF(A1="","",INDIRECT("'" & A1&"'!C1"))
now this might be a bit difficult to read so i've spaced out the INDIRECT
bit here to make it clearer:
INDIRECT ( " ' " & A1 & " ' ! C1 " )

Cheers
JulieD
 
Perfect, JulieD!!! Thanks so much.

Jordon

Hi Jordon

yes you can use the INDIRECT function to do this
e.g.

=IF(A1="","",INDIRECT("'" & A1&"'!C1"))
now this might be a bit difficult to read so i've spaced out the INDIRECT
bit here to make it clearer:
INDIRECT ( " ' " & A1 & " ' ! C1 " )

Cheers
JulieD
Click to expand...
 
Back
Top