| 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 |
| 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) | |||
Threaded Mode
