Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I insert a formula in a cell,which contains some text | Excel Discussion (Misc queries) | |||
Insert value from another cell AND text | Excel Worksheet Functions | |||
Need a macro to insert text in a cell that already has text.Excel | Excel Discussion (Misc queries) | |||
Insert Text From Different Cell | New Users to Excel | |||
Need macro to insert text string while inside cell (formula) | Excel Discussion (Misc queries) |