Insert text from one cell into formula in another cell.
 

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

Insert text from one cell into formula in another cell.
 

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

Insert text from one cell into formula in another cell.
 

=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