Check out the INDIRECT function in help

Tyro

"Deserthawk99" wrote in message
...
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