=INDIRECT(A1&"!"&"B1")
E eklarsen Dec 15, 2005 #2 Column "a" has the name of the worksheet that I want reference. I always want it to return the value on worksheet "Name" column B. Is there a formula other then doing it manually ="Sheetname"!B1
Column "a" has the name of the worksheet that I want reference. I always want it to return the value on worksheet "Name" column B. Is there a formula other then doing it manually ="Sheetname"!B1
