=IF(INDIRECT(A2 & "!A56")=1,0,"")

Note the change from " " to ""

You don't want a <space entered.


Gord Dibben MS Excel MVP

On Fri, 29 Feb 2008 20:49:00 -0800, Deserthawk99
wrote:

Lets say A2 has text in it Lets say Smith
a3 formula =if(smith!a56=1,0," ")

Smith is the name of another worksheet in the workbook and I'm using info
from that sheet, but I want to put the name in by taking what is in A3 and
inserting it into the formula.

Something like =if(A2!A56=1,0," ") I don't know the syntax or if it is
possible