formula for reffer to sheetname.....

jamiguel77

Board Regular
Joined
Feb 14, 2006
Messages
240
Office Version
  1. 2016
  2. 2010
  3. 2007
Platform
  1. Windows
  2. Web
2) i have 100 sheets, in first sheet named: General, and the rest: 4-00, 4-01, 4-02 and so so on...
in sheet General, have the names of the sheets in the cells: A1 to A100
4-00
4-01
4-02
....

my question is: in B1 to B100 i have this formula: ='4-00'!$A$3 i want change 4-00 by A1.... how to, i want take the name of the sheet of A1 cell or A2 or A3...

thanks
 

Some videos you may like

Excel Facts

How can you turn a range sideways?
Copy the range. Select a blank cell. Right-click, Paste Special, then choose Transpose.

jamiguel77

Board Regular
Joined
Feb 14, 2006
Messages
240
Office Version
  1. 2016
  2. 2010
  3. 2007
Platform
  1. Windows
  2. Web
i try: =CONCATENATE("=","'",A1,"'!$A$3") but not get the value... :(
 

Peter_SSs

MrExcel MVP, Moderator
Joined
May 28, 2005
Messages
46,227
Office Version
  1. 365
Platform
  1. Windows
Try
=INDIRECT("'"&A1&"'!$A$3")
 

Watch MrExcel Video

Forum statistics

Threads
1,108,973
Messages
5,525,988
Members
409,673
Latest member
Riseee

This Week's Hot Topics

Top