Insert text from one cell into formula in another cell.

  • Thread starter Thread starter Deserthawk99
  • Start date Start date
D

Deserthawk99

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
 
=IF(INDIRECT(A2 & "!A56")=1,0,"")

Note the change from " " to ""

You don't want a <space> entered.


Gord Dibben MS Excel MVP
 
Back
Top